Repeat column header when printing

1. Select the worksheet to print.

2. On the Page Layout tab, select  Print Titles.

3. Enter a reference to rows for labels into Rows to repeat at top.

4. Enter a reference for columns that contain row labels into Columns to repeat at left, and select OK.

Tip: Choose  Collapse dialog at the right of either field and select the row or column. 

For more info, see Print rows with column headers on top of every page.

1. Select the worksheet to print.

2. On the Page Layout tab, select  Print Titles.

3. Enter a reference to rows for labels into the Rows to repeat at top box, the reference for columns that contain row labels into Columns to repeat at left, and select OK.
   Tip: Choose  Collapse dialog at the right of either box and select the row or column. 

Repeating column headers when printing isn't currently possible in Excel for the web. You can, however, repeat column headers when printing in the Excel desktop app.

• To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.

  

Don't have the Excel desktop app? Try or buy Microsoft 365.