Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Print rows with column headers on top of every page

If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers on all pages when you have large, complex worksheets.

  1. Select the worksheet that you want to print.

  2. On the Page Layout tab, in the Page Setup group, select  Excel Print titles button icon Print Titles.

    On the Page Layout tab, click Print Titles

    Note: The Print Titles command will appear dimmed if you are working in cell editing mode, if a chart is selected on the same worksheet, or if you do not have a printer installed.

  3. On the Sheet tab, under Print titles, do one or both of the following:

    • In the Rows to repeat at top box, type the reference of the rows that contain the column labels.

    • In the Columns to repeat at left box, type the reference of the columns that contain the row labels.

      For example, if you want to print column labels at the top of every printed page, you could type $1:$1 in the Rows to repeat at top box.

      Tip: You can also choose  Collapse dialog button Collapse Dialog at the right end of the Rows to repeat at top and Columns to repeat at left boxes, and then select the title rows or columns to repeat in the worksheet. After you finish choosing the title rows or columns, select  Collapse dialog buttonCollapse Dialog again to return to the dialog box.

      Note: If you have more than one worksheet selected, the Rows to repeat at top and Columns to repeat at left boxes are not available in the Page Setup dialog box. To cancel a selection of multiple worksheets, select any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then choose Ungroup Sheets.

Next Steps

Once you have finished setting up your worksheet to include row and column headings or labels (also named print titles) on every page, print your worksheet.

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.

    Open Excel desktop app screenshot

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

  1. Select the worksheet that you want to print.

  2. On the Page Layout tab, in the Page Setup group, select  Excel Print titles button icon Print Titles.

    Print titles button screen shot

    Note: The Print Titles command will appear dimmed if you are working in cell editing mode, if a chart is selected on the same worksheet, or if you do not have a printer installed.

  3. On the Sheet tab, under Print titles, do one or both of the following:

    • In the Rows to repeat at top box, type the reference of the rows that contain the column labels.

    • In the Columns to repeat at left box, type the reference of the columns that contain the row labels.

      For example, if you want to print column labels at the top of every printed page, you could type $1:$1 in the Rows to repeat at top box.

      Tip: You can also choose  Collapse dialog button Collapse Dialog at the right end of the Rows to repeat at top and Columns to repeat at left boxes, and then select the title rows or columns to repeat in the worksheet. After you finish choosing the title rows or columns, select  Collapse dialog buttonCollapse Dialog again to return to the dialog box.

      Note: If you have more than one worksheet selected, the Rows to repeat at top and Columns to repeat at left boxes are not available in the Page Setup dialog box. To cancel a selection of multiple worksheets, select any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then choose Ungroup Sheets.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×