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

Part 10. Preparing for Printing Workshee... > Printing Repeating Row and Column Ti...

Printing Repeating Row and Column Titles

Open the File menu and select Page Setup; then select the Sheet tab on 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.

Select the row(s) containing the titles you want to repeat on each page of your worksheet; then press Enter to reopen the Page Setup dialog box with your selection.

Click OK. If you want, you can 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