Repeating rows @ bottom of each page
Repeating rows @ bottom of each page
(OP)
Does anyone know how to repeat rows at the bottom of each printed page in Excel? I have a 412 character text string that I want to be repeated on the bottom of each page, but the footer will only allow me to use 255 characters.
If I could somehow insert an image file into the footer, I could do it that way, but I haven't figured out how to do that either.
The problem is that I've got a spreadsheet that has text boxes scattered throughout that all say the same thing. They're set up to be at the bottom of each page, but once I get data on more than one page, and want to rearrange things or insert new rows, I have to spend too much time redoing the page breaks and rearranging everything just to get it all back on the same size page. My time could be better spent doing something productive.
Anyone have any tips?
Thanks.
John
If I could somehow insert an image file into the footer, I could do it that way, but I haven't figured out how to do that either.
The problem is that I've got a spreadsheet that has text boxes scattered throughout that all say the same thing. They're set up to be at the bottom of each page, but once I get data on more than one page, and want to rearrange things or insert new rows, I have to spend too much time redoing the page breaks and rearranging everything just to get it all back on the same size page. My time could be better spent doing something productive.
Anyone have any tips?

Thanks.
John





RE: Repeating rows @ bottom of each page
Check out John Walkers web site or books... that guy know every thing about excel!!! This link takes you to graphics in headers and footers.
http://j-walk.com/ss/excel/usertips/tip014.htm
Have a great day!
Scott
RE: Repeating rows @ bottom of each page
Thanks for the link, but that really only tells me how to repeat stuff at the top of the page. I already know how to do that. The bottom of the page is what I'm looking for. Oh yeah, and the version of Excel I'm using is 2000.
Thanks again.
John
RE: Repeating rows @ bottom of each page
If so then put the information into two different boxes. It may take some playing around to get the information to look seamless but it should work.
Rick Kitson MBA P.Eng
Construction Project Management
From conception to completion
www.kitsonengineering.com
RE: Repeating rows @ bottom of each page
Not per section.
I think the only real alternative you have (other than upgrading to Excel 2002) would be setting up a large enough margin and creating a custom watermark.