Repeat Top Row on Every Page in Excel

You folks might already know this, but I just learned something new about excel.

1.On the "Page Layout" Ribbon, click the “Print Titles”.

2. Click "Rows to repeat at top," and click the icon that looks like a spreadsheet.

3. Use your cursor to click and select the row you wish to appear at the top of every page.
4. Press the Enter and Click OK

You can use print preview to show you what it will look like.

P.S. For long printed documents, don’t forget to also add page numbers:

1. On the “Insert” Ribbon, click “Header & Footer”

   

2. Click on the Header or Footer area in which you’d like the messages to appear. This should open up the Header & Footer tools Context Sensitive Designer Ribbon.
   

   

3. Then select Footer and insert any template or design you own

   

   This should insert the insert the text “Page &[Page] of &[Pages]” where “&[field]” will be replaced automatically

4. You can also choose from any of the following fields:

   Element Name	Text
   Page Number	&[Page]
   Number of Pages	&[Pages]
   Current Time	&[Time]
   Sheet Name	&[Tab]
   File Name	&[File]
   File Path	&[Path]&[File]