How to Freeze Columns in Numbers

Written by emmanuelle douglas
  • Share
  • Tweet
  • Share
  • Email

Freezing columns in your spreadsheet is helpful when you need to view information in a long spreadsheet. When you're scrolling to the left or right, it can become cumbersome when you lose the first few rows you were reviewing. Freezing columns fixes this problem. Freezing makes the columns remain in place while you view additional columns in the long spreadsheet. To freeze columns in Numbers, you need to define the column and then activate this feature.

Skill level:


  1. 1

    Open Numbers and click "File." Click "Open" and browse your files for a workbook. Double click a workbook. The workbook opens.

  2. 2

    Select "View" and "Show Inspector."

  3. 3

    Select "Table Inspector" and locate "Headers And Footers." Click the drop-down list and specify how many header rows and header columns your spreadsheet contains. If you want those options frozen, select the "Freeze" option on the bottom of the "Headers And Footers" menu.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.