How to Freeze Rows and Columns in Apple Numbers

Learn how to freeze rows and columns in Apple Numbers. So you can make the row/column continue to show on the screen even if you scrolled past it on the file.

How to Freeze Rows and Columns in Apple Numbers

Freezing rows and columns take a few seconds. Follow these three easy-to-follow steps to get it done.

  • Step 1: Open Apple Numbers and Insert Information

    To get started, open Apple Numbers and insert your data/numbers.

  • Step 2: Right-Click the Row Number/Column Letter

    When you want to freeze a row or column, right-click on the number or letter respectively where it is located. A dropdown will appear.

  • Step 3: Click on ‘Freeze Header Rows/Columns’

    On the dropdown, you can easily see the option ‘Freeze Header Rows’ or ‘Freeze Header Columns’. Left click those options and you are all set!



Make sure there’s a checkmark on the Freeze Header Rows/Columns to make sure it is properly chosen.


Can I freeze both header rows and columns at the same time in Apple Numbers?

No, you can only freeze either the header row or column one at a time in Apple Numbers.

Will adding new columns or rows unfreeze them?

No, as long as the checkmark on the free header option is present, no other additional changes will unfreeze the row/column.

Can I freeze more than two header rows or columns in Apple Numbers?

Yes, you have the option to free more than one header row/column in Apple Numbers.