Repeat Rows At Bottom

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..

Hi,

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?
[/u]

Hello Guys,

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

Regards

In page setup under the sheet tab you can select "rows to repeat at top". But is it possible to do the same for rows at the bottom at the same time?

The footer option does not contain enough room for what I need to show.

I would like to put a grey bar with a height of 6 to print at the bottom of
each page where it works automatically like when you select lines to repeat
at the top...except I want to repeat at the bottom. I looked in the footer
section but I did not see anything there. Is there a way to do this?

Also, can you format dates in the footer like you can in a spreadsheet. I
want for example "WEDNESDAY FEBRUARY 2, 2005".


Thank you,

Steven

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!

CBaker01

experts

hello

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....

regds
devesh

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 .
Thanks

Greetings,

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,
David

Is it possible to repeat rows at bottom when printing a page on the excel worksheet?

Hi-

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.

Thanks,

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.