Topics Map > Office 365 > Excel

Microsoft Excel - Print the top row on every page from an Excel worksheet

On long printed worksheets, you can print column headers on each page so your readers won't have to go back to the first page to see the headers.

  1. On the Page Layout tab, in the Page Setup group, click Print Titles. 

    If Print Titles is dimmed, make sure you're not editing a cell, a printer is installed, and no charts are selected. 

  2. On the Sheet tab, in the Rows to repeat at top box, type $1:$1

    Page Setup dialog box

For more information, please visit the Excel help center.

If you have any questions, come by the Help Desk at Hardman & Jacobs Undergraduate Learning Center Room 105, call 646-1840, or email us at

Keywords:microsoft excel print top row every page headers   Doc ID:74964
Owner:John B.Group:New Mexico State University
Created:2017-07-31 11:16 MDTUpdated:2017-07-31 11:16 MDT
Sites:New Mexico State University
Feedback:  0   0