Thursday, February 24, 2005

Freezing Panes In Excel

Did you know you can freeze panes in Excel?

What this means is that you can set a portion of the screen either at the top, or the left or both that does not move as you scroll down or right.

Why would you do this?
If you have data in columns and you want to see the top header no matter how far down you scroll then select the cell in column a below the last row you want to "fix" in position. Use Windows | Freeze Panes to set the top rows.
If you have data at the left you want to see, eg a customer name while scrolling right to view columns of data then select the cell in row 1 one column to the right of the last column you want to "fix" in position. Use Windows | Freeze Panes to set the left columns.

Using any other location will fix all rows above and all columns left of the cell selected.


Posted by: Jethro | 10:34 AM |