Techie Tip of the Week: Repeat row(s) in Excel on printed pages

Need to repeat row(s) in Excel on printed pages?

Try this:

  • Excel 2003/2004/2008/2011
    1. On the File menu, click Page Setup.
    2. Click the Sheet tab.
    3. In Rows to repeat at top, enter the rows you wish to repeat, using the $ to indicate the row.
      Examples:

      • To repeat just the first row, enter $1:$1.
      • To repeat rows 1 and 2, enter $1:$2.
      • To repeat rows 1-5, enter $1:$5.
    4. Click OK.
  • Excel 2007/2010
    1. Click Page Layout.
    2. In the Page Setup group, click Print Titles.
    3. Click the Sheet tab.
    4. In Rows to repeat at top, enter the rows you wish to repeat, using the $ to indicate the row.
      Examples:

      • To repeat just the first row, enter $1:$1.
      • To repeat rows 1 and 2, enter $1:$2.
      • To repeat rows 1-5, enter $1:$5.
    5. Click OK.

Tags: , , , , , ,

Leave a Reply

You must be logged in to post a comment.