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]

4 comments:

  1. This is such a great resource that you are providing and you give it away for free. I love seeing websites that understand the value of providing a quality resource for free. It’s the old what goes around comes around routine. help with excel spreadsheets

    ReplyDelete
  2. This article is intended as an entry point for developers who, like me, either need to use C# to programmatic-ally interface with Excel (2007) or because it is their language of choice. This article will outline which references to include; how-to initialize a workbook; access a group of worksheets; or just one in particular; how-to access and change a cell. All the examples will use the VSTO (Visual Studio Tools for Office 2007) project templates. ppt translator

    ReplyDelete
  3. I really appreciate the kind of topics you post here. Thanks for sharing a piece of great information that is actually helpful,Tell me, can I learn this coding at home?Which is present in Kona Condos For Sale

    ReplyDelete

  4. Awesome post,Thanks for the detailed article on this topic. I would like to see more such awesome articles from you.I am truly pleased to read this information which carries lots of helpful data.Today, coding has become an important factor in the invention of new drones like the DJI Agras T40 . It has played an anchor role in the development of the world.Which we cannot ignore.

    ReplyDelete