Repeat the Header on First Line of Each Page in Excel

Can you tell me how to get the header to repeat on the first line of each page in Excel?

One thought on “Repeat the Header on First Line of Each Page in Excel

  1. andrew walker Post author

    Click on File at the top left. Then select Page Setup from the drop down menu. You will then be presented with a dialogue box with several options and tabs at the top of it. Select the Sheet tab. About three lines down you will see an option called Rows to Repeat at Top. To the right of this is a small icon with a red arrow. Click it. You can now select the rows you want to repeat at the top. Once selected, click back on to the small icon. Your selected rows should have populated the blank box next to Rows to Repeat at Top option. Click OK at the bottom. Completed!

Leave a Reply

Your email address will not be published. Required fields are marked *