Print Excel Title Columns and Rows

When you have a document that spans multiple pages, you might want your column titles/headers to be repeated on each page. Print Excel title columns and rows with these instructions.

    • Click the Page Layout tab
    • In the Page Setup group, click Print Titles
    • In the Print titles section, place your mouse cursor in either the Rows or Columns fields (depending on which you want to repeat when printed)

Print  Titles Excel

    • Click then drag-select the cells that contain the rows or column headers you want to repeat on each page

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!