Logo Background

Heading row in Excel

  • Many Excel spreadsheets have the first row as a heading row, containing the headings for the various columns in the spreadsheet. When the spreadsheet is printed, often the heading row is only printed on the first page. So, when reading the second, third, fourth, etc. pages of the printout, reference is often made back to the first page to determine the heading of a particular column. However, Excel has the feature to repeat a specified row(s) at the top of each printed page. Go to the ‘File’ menu > ‘Page Setup’. In the window that appears, click the ‘Sheet’ tab. The setting ‘Rows to repeat at top’ allows you to specify the rows to repeat at the top of each page. Click the button next to the input text area for this setting to allow easy selection of the rows to repeat. There is also the option to repeat specified column(s) at the left of each printed page.

Leave a Comment
Hi there. If this is the first time you are posting a comment it will not appear immediately, but needs to be approved. This is necessary in order to combat comment spam. However, once you have submitted a comment (which is subsequently approved) you do not need to go through this process again - the site remembers who you are and auto-approves your comments. Nifty eh? Anyway, sorry about the inconvenience that this may cause for your first comment post.