How to Print Headers, Titles, or Frozen Panes on an Excel Document

Learn how to print static columns and rows in Excel

Last Updated: November 7, 2024

Frozen panels will appear on every page of Excel on your screen, but what if you print the spreadsheet? This wikiHow will teach you how to print frozen panes (also known as "columns and rows") on every page in Excel.

Quick Steps

Open your Excel document.
Click the Page Layout tab at the top of the screen.
Choose Print Titles in the "Page Setup" section.
Enter the rows and columns you want to print on each page.
Click OK to save your selection.

Steps

Download Article

You can right-click the file in File Explorer (on Windows) or in Finder (on Mac). If you already have Excel open, go to File > Open and select the file you want to open.
It's next to File and Insert .

Advertisement
3
Click Print Titles . You'll see this in the "Page Setup" grouping with an icon of an Excel sheet and a printer.
- If that's greyed out, you might be actively editing a cell (check to see if your cursor is in a cell) or you might not have a printer connected to your computer.
4
Enter the rows that you want to print on each page next to "Rows to repeat at top." Make sure you're in the Sheets tab if you don't see "Rows to repeat at top" and "Columns to repeat at left."
- For example, if you want to repeat the first row, enter "$1:$1." ^{[1]
  X
  Trustworthy Source
  Microsoft Support
  Technical support and product information from Microsoft.
  Go to source}
- You can also click the header of the row to select it.
5
Enter the columns that you want to print on each page next to "Columns to repeat at left." Make sure you're in the Sheets tab if you don't see "Rows to repeat at top" and "Columns to repeat at left."
- You can also click the header of the column to select it, like "$A:$A" to freeze column A.
6
Click Ok . When you're ready to continue, you can print the document.
- Click Print Preview instead to see a preview of your page layout. ^{[2]
  X
  Research source}