Excel - how to have column labels repeat at top of each page?

Question

We want to have the selected rows and columns repeat at the top of each page

Answer 1

Go to file, page setup and click on the sheet tab. There is a box for "repeat rows at top". Click the box to the right of this box and then highlight the rows you want repeated. After the rows are highlighted, just click to the right of the box again, then okay.

Answer 2

For repeats on the printed spreadsheet, go to Page Setup (under File menu) and on the far right tab labeled "Sheet", select "rows to repeat at top" or "columns to repeat at top" and click on the little spreadsheet icon. It will go to the spreadsheet and you then click on the appropriate rows/columns you want repeated on the printed page.



If you are looking to display the rows and/or columns on the actual sheet as you are working on it (very helpful in a massive worksheet), you need to "Freeze Panes" found in the "Window" menu. Place your focus on the cell below and to the right of where you want the row and/or column to freeze and then click on the "Freeze Panes" menu item. Move to other areas in the worksheet to see if this is where you want the rows/columns frozen. If you want to change it, go back to "Unfreeze Panes" menu item (same place) and start over again.

Answer 3

If you're referring to when the sheet is printed, go to:

File > Page Set up then select the Sheet tab. Use the Print Titles area (specifically the Rows to Repeat at Top) to define your header rows.



If you want a certain row to stay on the screen as you scroll through, click on the row BELOW the row you want to stay on the screen, and then select Window > Freeze Panes

Answer 4

try this:

File Menu, Page setup, sheet tab, print titles, Rows to repeat at top :

click the red arrow and select rows you want to repeat

Answer 5

on the severe of the Excel pane, bypass to 'document', then opt for 'web page Setup'. this grants up a communication field. bypass to the 'Sheet' tab, the farthest one to the right on the severe of the pane. lower than the area "Print titles", there's a difficulty the position that you need to %. "Rows to repeat at suitable:" click on on the sq. that appears like slightly spreadsheet with an arrow interior the midsection of it. this can be on the a thoughts perfect of the textual content field the position you're presupposed to style in an reply. The communication field will immediately provide way precise right into a sparkling, one row severe field with "cyber web web site Setup - Rows to repeat at suitable:" alongside the utmost of the pane. Now bypass instantly to the Excel spreadsheet and click and carry at the same time as you spotlight rows a million and a couple of on the bright left of the pane. This ought to positioned those flashing dashed lines in the approach both rows on the particular spreadsheet. There ought to also be "$a million:$2" interior the communication field. Hit "enter" on your keyboard. the vast "web page Setup" communication field can might want to reappear and the small you'll have disappeared. "$a million:$2" should be interior the "Rows to repeat at best:" area. click on "ok" on the bottom precise hand nook of the communication field, and it ought to disappear. you've gotten only set the parameters for printing the utmost 2 rows of your spreadsheet on each and every cyber web web site it really is printed, in spite of how many columns are blanketed or in what order the pages are printed. once you save the spreadsheet, that decision will stay set to the utmost 2 rows. For some objective, in some variations of Excel, this can in common words be done by going to document, web page Setup. No shortcuts will allow you to to set the print selections. i'm particular powerful Microsoft has its motives for this, even with the undeniable fact that it should be quite infuriating once you do not understand the guidelines. wish that facilitates.