Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

Repeat Rows At Bottom

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi guys,

is there anyway to repeat rows at bottom?

or at least on the last page?

thanks in advance

View Answers     

Similar Excel Tutorials

Quickly Copy the Last Action to Multiple Cells in Excel
In the previous tutorial I talked about the Redo button in Excel and how using Ctrl + Y can be used to do the same ...
How to Resize Rows and Columns in Excel Quickly
Resizing rows and columns in Excel is an easy process. Simply left click in between the columns and drag the mouse ...
How to Add, Remove, and Rearrange Columns and Rows in Excel
Adding, removing and rearranging columns is as easy as resizing. You just select your columns or rows, right click ...
Highlight Rows that Meet a Certain Condition in Excel
In this tutorial I am going to cover how to highlight rows that meet a certain condition. To do this I use the Cond ...

Helpful Excel Macros

Filter Data to Show the Bottom X Percent of the Data Set in Excel - AutoFilter
- This free Excel macro filters data to display the bottom X percent of the data set in Excel. This is a great macro to u
Filter Data to Show Only the Bottom 10 Items in Excel - AutoFilter
- This Excel macro filters a selection of data in order to display only the bottom 10 items in the list or data set. This
Filter Data to Show the Bottom X Number of Items in Excel - AutoFilter
- This free Excel macro filters a data set to show the bottom X number of items from that data set. This macro is really
Filter Data to Show the Bottom 10 Percent of a Data Set in Excel - AutoFilter
- This free Excel macro filters a data set to display the bottom 10 percent of the data set in Excel. This is a great mac
Delete Hidden Rows in a Workbook
- This macro will delete hidden rows from every worksheet in an entire workbook. However, note that this will only delete

Similar Topics

I've searched but can't find a suitable answer to this situation: how do you tell excel to repeat rows at the BOTTOM of each print page?
It's easy enough in page setup to get repeat rows at the top but I want to do exactly the same at the bottom.
The rows I want to reappear stay exactly the same (quantity, height etc) so it doesn't have to be too fancy!
I don't think it can be done at all in page setup - unless someone else knows something different...
Any ideas anyone?
Thanks in advance.

Sorry guys...

I'm looking for the opposite instruction... I need to use rows to repeat on top... and rows to repeat on the bottom...

Can some one help me with the instrcution "ROWS TO REPEAT ON THE BOTTOM"

I know how to use the top... but I don't know if there is a way to do tha same at the bottom

Thank you

I am aware that we can repeat rows at Top of each Page, but i want the rows to repeat at bottom of each page.
Please provide me the macro or the procedure to do so.
Help will be highly appreciated.
Thanks and hope to get a solution.

I have a sheet with activex controls at the top and bottom and cells in between that the user can edit. I know you can repeat cells at the top and bottom of every page that is printed, but is there a way to repeat the controls at the top and bottom of every page?



As we repeat rows at top and coloumn at left while printing using page setup option. can we repeat the rows at bottom and coloumn at right... if yes then how ???? pls help....


I'm using Microsoft Office Excel 2007 in 'Page Layout' view.

I am using ' Page Layout > Sheet Options > Rows to repeat at top: ' to use the same 4 rows at the top of every page I start working on.

What I need to figure out it how to do something similar to the bottom of only the pages that get data added.

(and if I'm going about this all wrong... are the any recommendations on how to format a word document so that there are 'fields' that can be easily referenced for lookups in an excel sheet?)

I know there is a feature via the print setup option to allow you to apply "Rows to repeat at top".
But I was wondering if there is a feature to allow the user to repeat rows at the bottom?

Is it possible to repeat rows at bottom of the page in the print out like rows to repeat at top..


Anyone have any idea's on how to add a range of cells to the end of everypage that prints?

Something like in page setup you can add rows to repeat at the top...but I want rows at the bottom to repeat?

My range would be range("A359:I377") On every page that prints.

Thank You, Mike

I have an excel spread sheet that I need the bottom 6 rows of the first page to repeat on all of the other pages when I print it out. I know how to do it from the top of the page. Is there a way to make this work?

Can i define a serie of rows to repeat (printing) at the bottom of each page like i can define it to the top?

Hello Guys,

I wonder if it is able to repeat rows at bottom of a worksheet?


Is there any way of repeating multiple sets of rows at the top of subsequent pages?

It's difficult to put into words so as an example, I want to repeat rows 1 & 2 on each subsequent page, so I go to page setup>rows to repeat at top and enter them there - no problem.

But, can I somehow also get Excel to repeat rows 10 & 11 as well as rows 1 & 2, but not with rows 3 - 9?

Any help greatly appreciated!


This is just an idea - would it be possible to repeat the navigation bar now located at the top of the page again at the bottom?

I often find myself reading long threads and than having to scroll back up to the top of the page to check for new posts, access my subscribed threads and so on. Repeating the navigation bar at the bottom would save me a llot of scrolling and make my life just that little bit easier.

Alternativly, why not simply include a "Back to the Top" button?

What does everyone else think about that?

I'm using the camera feature to show a pivot table report at the bottom of another pivot table report, but when I do so it disables the rows to repeat at top function from the page setup options - it does show the first row of my selected rows to repeat at top, but not the remaining 13 rows. Anyone else have similar issues or recommendations?

I made a spreadsheet and I want the top 5 rows to repeat on every page. I select my area, go to print preview, then page setup. But when I go to the "rows to repeat at top" button, it's grayed out so I cant pick it. How do I set my spreadsheet up so it prints rows 1-5 at the top of every page?

I want to generate a partlist for electronic parts that we have here
every page of a partlist should have a constant table at the bottom of it
so we should repeat this table in every page . i want to know that how can i repeat this table at the bottom of all pages automatically without the need for copy&paste of that .


Please do not tell me to use headers. I MUST use a function within a cell.

Why? ..because my customer has a complex header using the "repeat rows at top of page". These so-called header rows have formulas and functions and can not be re-created in the "Page Setup > Custom Header" field. They do not want the page number above their header, or at the bottom of the page. The want me to display the (page) and (pages) within the repeated rows.

Note: The same rows repeat at the top of every page, so the same cell that displays the page number info needs to keep track of how many times it has been displayed. I thought that maybe a global variable (counter) could be used.

Or, how about a custom Print function that continuously updates a global page number variable as it iterates through the pages using set print range - effectively printing one page at a time.

I know VBA, so solutions involving VBA are fine.

Thanks in advance,


I have inserted a page break on my sheet, and I have two rows of data at the bottom of page one that I would like to also be printed at the top of page two.

Other than making a copy of the rows and pasting them right after the original rows and inserting a page break between the two, is there a way to automatically have those rows print?

Not sure if it complicates things or not, but I'm also using print titles to repeat the top two rows of the sheet on the second page.


I have a Tab in a worksheet that can be up to 100 print pages long. I have a macro that automaticly hides all the unused rows prior to print. I also have the top couple of rows repeated on each page when printing.

When I print this out the repeat rows are printed out for every page. I end up with the repeat rows printed for the pages where there are hidden rows. I don't really want this to happen. Deleting the rows prior to print is not really an option, which I know would solve this.

Is there a way to stop the repeat rows printing when there are no rows of data to print.

Thank you

I need a way to fix a print problem. When I go into File - Page Setup, and I
choose which rows to repeat at the top ($1:$5) and select which columns to
repeat at left ($A:$A), the rows at the top never print completely on pages 2
through the end. Only on the first page can I see the entire title and
subtitle. On the remaining pages they get cut off where Column B would
begin. Can I fix this?

Dear Concerned,

when i remove print last 5 rows of the excel data should be repeated in every page at the bottom of each page. how to do this is excel 2007.

I have multi-page output with a need to have a row repeated at the bottom of each page. in the page setup dialogue box, under the sheet tab, there is an ability to select a row to print at top. does anyone have any ideas how to get a row to repeat at the bottom of each page of the output?

Hi, I have a column where I need to repeat the same formula a set
number of rows apart. Is there a simple way to do this? The cell
references are relative and it would be nice if I could make this
formula repeat in several worksheets, yeah same places and same column
in each worksheet. (L). While the L column ends in different rows in
each worksheet, not necessarily at the bottom of the column. The
formula to be copied references data in the d column so when I run out
of data in the d column in each sheet can it repeat to the next
worksheet? Also the k column has a label of text for the result of that
formula. This is excel 2004 Mac. Any Ideas? steveo

I have a problem formatting my report in the way I would like to.

I want to repeat the top 10 rows and the first 4 columns of my report on
each page when I print it (therefore the text I want repeated makes an upside
down L shape)

I know that I need to do the following:

Rows to repeat: $1:$10
Columns to repeat: $A:$D

However, the report 'headings' in the first 10 rows include merged cells
(e.g I merge 6A - 6T). This causes a problem in the printed version of the
report, as any header text which is not 'alligned' with columns A-D will not
appear on any page other than the first page.

Only the text alligned with columns A-D is repeted on each page - the other
text that I want to see from the first 10 rows is not vissible

Is it possible to get round this without using the actual 'Headers' facility?

Thanks in advance