Repeating rows @ bottom of each page

[Canoman]

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

 

[ByDesign]

John

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

 

[Canoman]

Scott,

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

 

[RDK]

Doesn’t the 255-character limit apply to each of the three positions for custom footers?

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

http://www.kitsonengineering.com

 

[1raven]

The 255 limit applies to the whole footer.
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.