How to Print First Row or Column on Every Excel Page

Quick Tips

• Add a header to print your company name, address, logo, etc., on every page.
• Use Freeze panes to lock the 1st row and 1st column of an Excel sheet.
• Uncheck Headings (View > Show pane) to hide Column name and Row numbers.

Print the First Row or Column on Every Excel Page

Step 1: On your workbook, select the desired sheet and navigate to the Page Layout tab on the ribbon.

Step 2: Then, click on the icon for Page Titles under the Page Setup section.

Step 3: In the Page Setup modal window, switch to the Sheet tab and spot the section for Print titles. It includes row and column options.

Note: Though we focus on the header row, the setting can also be applied to columns.

Step 4: To set up printing of the top row on each page, click on the Arrow up button in front of ‘Rows to repeat at top’ text box. For columns, take the second one.

Step 5: That will take you to the Excel sheet along with a dialog box. Click row number 1 (on the sheet) and press the arrow-down button in front of it.

Here, you can select multiple rows on each page if you wish to repeat them. Generally, you would want the top row and, in rare circumstances, the leftmost column.

Step 6: Back in the Page Setup modal window, you will see the text boxes populated with the row/column values to repeat on each page. You can choose Print Preview to ensure the print includes a header or columns on all pages.

In the print preview, check whether the settings work. Note that the settings are sheet-specific and do not apply to the workbook.

If you cannot print, check out the guide on Excel printing fixes.

FAQs

How Do You Print Row and Column Numbers When Printing in Excel?

Sometimes, you also want to print row headings 1, 2, . . . and column headings A, B, . . . To achieve this, navigate to Page Layout > Sheet Options and check the Row and column headings box in the Print section.

Why Is Print Titles Button Greyed Out?

If you cannot access the Print Titles button, it might be because you are editing a cell or have a chart selected. Similarly, if you cannot use the Rows to repeat at the top spreadsheet icon, it could be because you have selected multiple worksheets within your workbook.