- Select “View” from the drop-down menus at the top of Excel
- Click on “Header and Footer…”
- In the “Page Setup” window you should see 4 tabs, click on the “Sheet” tab.
- Under the “Print titles” section (in blue), the first option is “Rows to repeat at top:” – click on the button to the end of the text box.
- Select the row where your column headers are located (typically row 1).
- Click “Ok” to save your changes
No comments:
Post a Comment