Hi,
This is my first attempt at using Numbers.
I am trying to work with an Excel spreadsheet in Numbers. The document has rows and columns frozen but in Numbers they aren't.
I then try to freeze those rows and columns in Numbers but didn't appear to work even though the freeze options for both rows and columns were ticked.
Please advise, thank you.
MacBook Pro 14″, macOS 12.4
In Numbers you can only freeze header rows and header columns. Up to 5 of each. They have to be headers. One way to specify the number of headers is in the Format sidebar. Note that you do not want to turn a row or column into a header if it is not actually "header" information. They are special cells and are treated differently in functions/formulas than the "data" cells. They may get ignored by some functions.
In Numbers you can only freeze header rows and header columns. Up to 5 of each. They have to be headers. One way to specify the number of headers is in the Format sidebar. Note that you do not want to turn a row or column into a header if it is not actually "header" information. They are special cells and are treated differently in functions/formulas than the "data" cells. They may get ignored by some functions.
Freezing rows and columns can be important in Excel, where you work with one big grid of cells on a worksheet.
But Numbers has a different design that makes it easy to have multiple tables on the same sheet (see the templates at File > New in the menu for examples).
So in Numbers, instead of trying to freeze many rows or columns in a large table, it is generally more efficient to to break your work up into smaller, special-purpose tables.
If you do that then the 5-Header Row, 5-Footer Row, and 5-Header Column limits generally are more than sufficient, and the general idea trying to "freeze panes" is soon forgotten as it isn't really needed.
SG
Freezing Panes of an .xlsx Doc In Numbers
