Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel: Applying Header / Footer To Entire Workbook


  • Please log in to reply
5 replies to this topic

#1 Hal06

Hal06

  • Members
  • 917 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:New York, New York, USA
  • Local time:08:57 PM

Posted 04 June 2008 - 10:59 AM

Is there an easy way to apply the same header/footer to an entire workbook in Excel 2003 without having to manually do so on each worksheet? Thanks.

BC AdBot (Login to Remove)

 


#2 Code Poet

Code Poet

  • Members
  • 96 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:North Carolina, USA
  • Local time:08:57 PM

Posted 04 June 2008 - 01:45 PM

If you use custom headers and footers you can have one to a worksheet. If you try to apply a different custom header or footer it will over write the first one.

Are you using the header and footer feature in Excel or are you just creating headers and footers in rows?

#3 Hal06

Hal06
  • Topic Starter

  • Members
  • 917 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:New York, New York, USA
  • Local time:08:57 PM

Posted 04 June 2008 - 01:57 PM

I am using the header/footer feature in page setup. So far, I've had to manually insert them on each worksheet.

#4 Code Poet

Code Poet

  • Members
  • 96 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:North Carolina, USA
  • Local time:08:57 PM

Posted 04 June 2008 - 05:53 PM

hmmm...what versionof Excel are you using. I'm still on 2000 :thumbsup:

#5 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,568 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:08:57 PM

Posted 04 June 2008 - 11:22 PM

I do it all the time the lazy way :thumbsup:
Select one worksheet. Setup a page with header and footer.
I normally do workbook name on the left, date in the center, page on the right in the footer.
Click OK, OK when done.
Now select next sheet.
Press the shift key and select the remaining sheets (group selection)
To propagate the same setup: Edit > Repeat page setup
Having done that, now click the first sheet you selected in order to disable that group selection.
A common mistake is to begin editing one of those selected sheets and it goes to them all, so be careful!

#6 Hal06

Hal06
  • Topic Starter

  • Members
  • 917 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:New York, New York, USA
  • Local time:08:57 PM

Posted 05 June 2008 - 03:18 PM

Thanks.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users