10450 Views 5 Replies Latest reply: Jan 5, 2011 8:40 AM by Badunit
Scrolling with frozen rows or columns in Numbers is different than in Excel. Only Header rows and columns can be frozen. Headers are Top and Bottom rows and Left columns (0-5 in all cases) that have special properties, among them the ability to freeze. Generally speaking, Top Header Rows are intended for Titles, as are Header Columns while Bottom Header Rows are for summary data. When an expression refers to an entire column or row, the Headers are excluded.
I have had the same problem; I've read the instructions / Help section many times, and it seems that I should be able to freeze the first column (or several) but when I try that option, what happens is nothing like I expect (based on Excel). Are you saying that it IS possible to hold the left-most column in place when the rest of the spreadsheet is scrolled across? I have not been able to make that happen despite many tries. Thanks very much. If it IS possible would you please expand on the cryptic so-called help screen message?
Yes, it is possible to freeze the leftmost column. The column MUST be a header column. You can have up to five header columns and they will all be frozen (or not).
The table that is in the Blank template has a header column so let's start there.
Create a new document based on the Blank template.
Select the table.
Go to the Table menu and click on Freeze Header Columns.
That's all there is to it.