• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 9. Printing in Excel > Printing Repeating Row and Column Titles

Printing Repeating Row and Column Titles

Choose File, Page Setup, and click the Sheet tab in the Page Setup dialog box.

Click the Rows to repeat at top selection box in the Print titles area. Excel shrinks the Page Setup dialog box, making your focus the worksheet on your desktop.

Click the row containing the titles that you want to repeat on each page of your worksheet, and press Enter to reopen the Page Setup dialog box with your selection inserted.

Click OK. If you like, view the worksheet in Print Preview mode to get an idea of what your printed worksheet will look like with repeating row headings.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint