×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Repeating rows @ bottom of each page

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

RE: Repeating rows @ bottom of each page

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

RE: Repeating rows @ bottom of each page

(OP)
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

RE: Repeating rows @ bottom of each page

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
www.kitsonengineering.com

RE: Repeating rows @ bottom of each page

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources