Microsoft Excel: How to print row and column headers on every page

Microsoft Excel: How to print row and column headers on every page

Microsoft Excel: How to print row and column headers on every page


In printing spreadsheets; the top row is printed only on the first page. Here is how to repeat the header row on your print jobs.

Repeat Excel header rows on every page
Your Excel document turns out to be long and you need to print it. You go to the print preview and find out that only the first page has the column titles at the top. Here is how to specify the Page Setup settings to repeat the top row on every printed page.

1. Open the worksheet that you’re going to print.

2. Switch to the PAGE LAYOUT tab.

3. Click on Print Titles in the Page Setup group.




4. Make sure that you’re on the Sheet tab of the Page Setup dialog box.

5. Find Rows to repeat at top in the Print titles section.

6. Click the Collapse Dialog icon Select range next to “Rows to repeat at top” field.




The Page Setup dialog window is minimized and you return to the worksheet.
Notice that the cursor changes to the black arrow. It helps to choose an entire row with one click.




7. Select a row or several rows you want to print on every page.

Note: To select several rows, click on the first row, press and hold the mouse button, and drag to the last row you want to select.

8. Click Enter or the Collapse Dialog button again to return to the Page Setup dialog box.




Now your selection displays in the Rows to repeat at top field.




Note: You can skip steps 6-8 and enter the range using the keyboard. However, pay attention to the way you enter it – you need to use the absolute reference (with the dollar sign $). For example, if you want to see the first row on every printed page, the reference should look like this: $1:$1.

9. Click on Print Preview to see the result.



Now you know exactly what the columns mean on every page.


Get a header column on every printout

When worksheets are too wide, the header column will only be on the left, first printed page. To make your document more readable, follow the steps below to print the column with row titles on the left side of every page.

1. Open the worksheet that you want to print.

2. Go through steps 2-4 as described above.

3. Click the Collapse Dialog button to the right of the Columns to repeat at left box.




4. Pick a column or columns you want to see on every printed page.




5. Click Enter or the Collapse Dialog button again to check if the selected range is displayed in the Columns to repeat at left field.

6. Press the Print Preview button in the Page Setup dialog box to look at your document before printing.



Now you don’t have to turn the pages back and forth to find what the values in each row mean.


Excel normally refers to worksheet columns as letters (A, B, C) and rows as numbers (1, 2, 3). These letters and numbers are called row and column headings. Row and column titles are printed only on the first page by default, and headings are not printed at all. If you want to see these letters and numbers on your printouts, do the following:

1. Open the worksheet you want to print with the row and column headings.

2. Go to the Sheet Options group on the PAGE LAYOUT tab.

3. Check the Print box under Headings.




Note: In case you still have the Page Setup window opened on the Sheet tab, check the Row and column headings box in the Print section. It also makes the row and column headings visible on every printed page.




4. Open the Print Preview pane (FILE -> Print or Ctrl+F2) to check the changes.




The Print Titles command can help simplify your work. Having header rows and columns printed on every page allows you to understand the information in the document more easily. You won’t lose your way in the printouts if row and column titles on each page.

    • Related Articles

    • Microsoft Excel: Turn table headers on or off

      Microsoft Excel: Turn table headers on or off When you create an Excel table, a table Header Row is automatically added as the first row of the table, but you have to option to turn it off or on. When you first create a table, you have the option of ...

    • Microsoft Excel: How to select rows and columns

      Microsoft Excel: How to select rows and columns In this article, we will guide you through various methods to select rows and columns in Excel, including some helpful shortcuts. Efficiency is the name of the game when it comes to Excel. Selecting ...

    • Microsoft Excel: How to select every other row or every nth row

      Microsoft Excel: How to select every other row or every nth row In this article, we will explore different methods to select every other or every nth row in Excel, whether you are working with small datasets or larger ones. If you’ve ever found ...

    • Microsoft Excel: Text to Columns

      Microsoft Excel: Text to Columns Data imported from other spreadsheets or databases is already separated into fields, using something called a field delimiter: a comma, tab, space, or custom character – to separate one field from another. These ...

    • Microsoft Excel: How to freeze Rows & Columns

      Microsoft Excel: How to freeze Rows & Columns Freeze the Top Row or First Column Click on the View tab on the Excel Ribbon. Click the drop-down for Freeze Panes. Click Freeze Top Row – allows scrolling down many rows and still shows the top row. OR ...