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.