How to freeze the header row in a spreadsheet

Learn how to freeze the header row in Excel and Google Sheets so column labels stay visible while scrolling, and how to repeat headers when printing.

3 min read5 viewsHow to freeze the header row in a spreadsheet
— · 0 votes
Contents
  1. Freezing the top row in Excel
  2. Locking the header row on a Mac
  3. Repeating headers when printing
  4. Questions about freezing header rows
  5. What is the shortcut to freeze the top row in Excel?
  6. How do I freeze the header row in Google Sheets?
  7. Why does my frozen row not stay visible?
  8. Can I lock the header row so nobody can edit it?

Freezing the header row in a spreadsheet keeps your column labels visible at the top of the window as you scroll through long lists of data. Excel, Excel for Mac and Google Sheets each offer a freeze command that locks the top row in place, and Excel can also repeat that row on every printed page. The steps below show where the command lives in each app, how to lock a header row, and what to check when the lock does not behave as expected.

Freezing the top row in Excel

Excel places the freeze command on the View tab under the Freeze Panes button. With the first row visible, choose Freeze Top Row and Excel locks row one while the rest of the sheet scrolls beneath it. Freeze Panes instead locks every row above the active cell, so select a cell in row two for the same result. A thin line under the frozen row marks the boundary, and the same menu holds the unfreeze command.

Locking the header row on a Mac

Excel for Mac uses the same View tab, Freeze Panes button and Freeze Top Row command as the Windows version. The ribbon may sit in a different spot on the window, but the menu names match closely enough to follow the same steps. Google Sheets freezes rows through its own View menu, where Freeze lists the rows above the current selection. Selecting row one and choosing that option keeps the labels in view on any operating system.

Repeating headers when printing

A frozen row affects the screen only, so a printed sheet can still lose its labels after page one. Excel handles this with print titles, set in the Page Layout tab under Print Titles. Mark row one as the row to repeat, and each printed page carries the header again. Print titles and the freeze command are separate settings, so a sheet can use one, both or neither.

Questions about freezing header rows

What is the shortcut to freeze the top row in Excel?

Excel has no default keyboard shortcut for freezing the top row, so the command is reached through the View tab. You can add Freeze Panes to the Quick Access Toolbar and reach it with the Alt key sequence. Some keyboards allow a custom macro, but that requires setting it up yourself. The menu route stays the same in every version of Excel.

How do I freeze the header row in Google Sheets?

Google Sheets freezes the header row from the View menu, where the Freeze submenu lists the rows above your current selection. Click a cell in row two, open View, choose Freeze and pick the row option. A gray line appears under the frozen row once it is locked. Removing the freeze uses the same menu and a no rows option.

Why does my frozen row not stay visible?

A frozen row can seem to disappear when the command locked a different row than you expected. Freeze Panes in Excel locks everything above the active cell, so selecting a cell lower down locks extra rows. Check where the boundary line sits and unfreeze before choosing the row again. In Google Sheets, confirm the freeze menu shows the row you meant to lock.

Can I lock the header row so nobody can edit it?

Freezing a row keeps it visible but does not stop anyone from editing its cells. Protection is a separate setting: Excel and Google Sheets both allow you to protect a sheet or range. Protect the header cells with a password if the labels must stay unchanged. Freezing and protection solve different problems, so use both when you need each one.

Latest articles