Home : Freeze Cols and Rows
Q11160 - INFO: Freeze Cols and Rows

Used to freeze the columns and rows so they do not scroll with the rest of the spreadsheet. 

 

 

To keep an area of a report visible while you scroll to another area of the report, you can lock the rows and columns in one area by freezing.

When you freeze columns and rows, you keep those columns and rows visible when you scroll in the worksheet.

Also, the frozen columns and rows are printed at the top of every page of a report when it is output.  Therefore, you can use this feature to act like a header. 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 5/8/2008 1:41 PM.
Last Modified on 10/8/2008 4:20 PM.
Last Modified by Scott Dorner.
Article has been viewed 2926 times.
Rated 6 out of 10 based on 3 votes.
Print Article
Email Article