If you have created a large table that continues beyond the edges of your screen, you can freeze a header row or column to keep it visible as you scroll through your table. Here’s how to set up your headers and footers in four simple steps.
1 Set up your spreadsheet
Open a blank spreadsheet and Numbers will create a table with one header row and column highlighted in grey to distinguish them from other cells in your table. Begin entering data.
2 Adjust your headers
To adjust the number of table headers, tap the paintbrush icon in the top toolbar and select Headers. Now tap the ‘+’ or ‘–’ symbol next to Header Rows and Header Columns as necessary.
In the same Headers menu, next to Freeze Rows and Freeze Columns, you can swipe the slider to the right to turn this option on. It will fix the header rows or columns in place.
4 Add footers
Footers are useful to perform functions on entire columns in your table. In Headers, tap the ‘+’ icon next to Footer Rows and the footers will appear at the bottom of your table.