« What is the electron pair geometry of the following?
Algebra - Simplifying Radical Expressions »

How do I repeat rows on each page of a worksheet in Excel?

I need to insert the same data from two rows on all pages of a worksheet, and not in the footer, at the bottom of a table on mutliple pages. I do not know how to do this…any help would be appreciated!

If you are trying to get ‘rows to repeat at the bottom of the page’ in Excel, that cannot be done in Excel. It might be possible to do it with a VBA macro.

Of course, as you are probably aware, there is a way to get rows to repeat at th top of the page. File > Page Setup and select the Sheet tab. Under Print Titles > Rows to repeat at top enter the rows to repeat. For rows 1 and 2, enter $1:$2

This entry was posted on Monday, July 6th, 2009 at 8:28 pm and is filed under worksheet. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “How do I repeat rows on each page of a worksheet in Excel?”

  1. neil b Says:
    July 7th, 2009 at 1:43 am

    If I’m stuck with Excel I go to this site:-

    http://www.techonthenet.com/excel/index.php

    It has always had the answers.

    Hope this helps.
    References :

  2. garbo7441 Says:
    July 7th, 2009 at 2:20 am

    If you are trying to get ‘rows to repeat at the bottom of the page’ in Excel, that cannot be done in Excel. It might be possible to do it with a VBA macro.

    Of course, as you are probably aware, there is a way to get rows to repeat at th top of the page. File > Page Setup and select the Sheet tab. Under Print Titles > Rows to repeat at top enter the rows to repeat. For rows 1 and 2, enter $1:$2
    References :

Leave a Reply