Excel: Repeat Top Row on Every Page

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

  1. On the “Page Layout” Ribbon, click the “Print Titles”.
    print tiles
  2. Click “Rows to repeat at top,” and click the icon that looks like a spreadsheet.
    page setup
  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”
    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.
    footer bar

    header & footer tools

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

    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]

No comments:

Post a Comment