×
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!
*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

Excel Header/Footer
2

thread770-95306

Excel Header/Footer

Excel Header/Footer

(OP)
I use several "worksheets" within a particular "workbook" (or file).  Very often I need the headers and footers to be the same for all worksheets.  It is a slow process to open one sheet and enter a custom header/footer, then piece by piece copy and paste it into the custom header/footer for the other sheets.
Is there a way to make a global header footer, or automatically copy a header/footer into multiple worksheets?
Replies continue below

Recommended for you

RE: Excel Header/Footer

Highlight the sheets you want to have the same header by holding  the shift key and left clicking on the desired sheets. Go to file - page setup and make your changes and they will be placed on all sheets.

Caution if you do not clear the multi-sheet selection and change a cell on one sheet it will change the cells on all selected sheets.

RE: Excel Header/Footer

(OP)
I just tried it, excellent!

RE: Excel Header/Footer

Check out ASAP Utilities from www.asap-utilities.com - this great FREE toolkit has all sorts of tools for doing this - and numerous other common and not-so-common tasks in Excel.

Hope this helps.

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! Already a Member? Login


News
Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close