How to freeze the top row and first column in Excel on a Mac

If the headings disappear when you scroll through a workbook, freeze the first row. If column A holds names or invoice numbers, freeze it too. To keep both in view, select B2 before freezing panes. This keeps the row above and the column to the left of that cell visible.

In Microsoft Excel for Mac

Open the workbook, then choose the View tab. Pick Freeze Top Row for row 1 or Freeze First Column for column A. To freeze both, select B2, then choose Freeze Panes. Scroll down and to the right to check that both labels stay visible. If the freeze controls are dimmed, select Normal on the View tab and try again.

In Office Alternative on Mac

Open the .xlsx workbook in Office Alternative, select the worksheet, and switch to Edit Mode if it opened in View Mode. On the View tab, open Freeze Panes and choose:

  • Freeze Top Row to keep row 1 in view.
  • Freeze First Column to keep column A in view.
  • Freeze Above and Left of Selection to keep both. Select B2 first.

For more than one row or column, select the cell just below and to the right of what you want to keep on screen. For example, C4 keeps rows 1 through 3 and columns A and B visible. Save the workbook as .xlsx to keep the setting when you reopen it.

Which cell should you select?

What you want to keep visibleCell to select before freezing both ways
Row 1 and column AB2
Rows 1 and 2, and column AB3
Row 1, and columns A and BC2
Rows 1 through 3, and columns A and BC4

Suppose an invoice tracker has client names in column A and invoice numbers in column B. The heading row is row 1, and you want to scroll right to the paid date while still seeing both identifiers. Select C2. If the spreadsheet also has a report title above its headings, select C3 to keep the title and the headings. Try scrolling diagonally after freezing so you can see whether both boundaries are where you expect.

The frozen block starts at the top and left of the sheet. For example, if your useful headings are on row 5, freezing above row 6 keeps rows 1 through 5. If that takes up too much screen space, put your headers near the top in a working copy and keep the original file as it was.

Change or remove frozen panes

From View, choose Unfreeze Panes. Select a different cell and freeze again if you want a different boundary. Freeze panes applies to the current worksheet, so repeat it on other tabs only if they need it.

CSV files store cell values and can’t keep frozen panes. For printing, Excel has a separate Print Titles setting. Office Alternative repeats frozen top rows on printed pages. For page scaling and print setup, follow the Excel printing guide for Mac.

If the headings still disappear

  • The wrong row is staying visible. Unfreeze the panes and check which cell is selected. With B2 selected, the frozen line sits above row 2, so row 1 stays in view. Pick a cell farther down to keep more rows.
  • Only one direction stays fixed. Freeze Top Row and Freeze First Column each have a single purpose. To keep a row and column together, select the boundary cell and use the command that freezes both.
  • It works until you reopen the file. Check the file extension of the copy you reopened. If you started from a CSV, save an Excel workbook instead and reopen that .xlsx copy. If the workbook has several sheets, check the tab where you made the change.

Frozen panes change how the sheet scrolls. They don’t protect cells from editing, reorder records, or change formula results. If you’re sending the workbook to someone else, open the saved copy once to check that the intended rows and columns are still visible.

Official sources