Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
How To Freeze Excel Rows ?
Posted by - NA - on 30 March 2006 08:10 AM
|
|
|
Solution: Suppose you're working on an Excel worksheet and you place all your header information in the first two rows (1 and 2). Once the worksheet is finished, you scroll down to view more cells and the header information scrolls off the top so it's no longer visible. There's a way to scroll an Excel worksheet without losing the headers. You can freeze the rows that contain the headers. To do this, click in Cell A3 and choose Windows/Freeze Panes. Rows 1 and 2 will now remain in view as you scroll down through your worksheet. To unfreeze the rows, choose Window/Unfreeze Panes. | |
 (147 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)