Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-03-2013, 02:01 PM
Mendopaul Mendopaul is offline How add 3 footer items to all sheets in workbook? Windows 7 64bit How add 3 footer items to all sheets in workbook? Office 2010 64bit
Novice
How add 3 footer items to all sheets in workbook?
 
Join Date: Aug 2009
Location: Northernmost Coast of California
Posts: 15
Mendopaul is on a distinguished road
Default How add 3 footer items to all sheets in workbook?


I'm having trouble getting 3 footer items (date, file, page of page) to stick on each sheet of my workbook. I can't seem to get more than one on the page. Thanks in advance.
Reply With Quote
  #2  
Old 12-04-2013, 06:15 PM
macropod's Avatar
macropod macropod is online now How add 3 footer items to all sheets in workbook? Windows 7 32bit How add 3 footer items to all sheets in workbook? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you select all the worksheets, you can add a common header and/or footer to all of them in one go. An alternative is to create the header and/or footer for one worksheet and then, without doing anything else, select each of the others in turn and press F4.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-05-2013, 11:06 AM
Mendopaul Mendopaul is offline How add 3 footer items to all sheets in workbook? Windows 7 64bit How add 3 footer items to all sheets in workbook? Office 2010 64bit
Novice
How add 3 footer items to all sheets in workbook?
 
Join Date: Aug 2009
Location: Northernmost Coast of California
Posts: 15
Mendopaul is on a distinguished road
Default

Thanks Macropod for the info. By "selecting all the sheets" are you referring to clicking on a tab at the bottom and clicking "select all sheets"? Seems obvious but thought I'd best check. And I still have not been able to show more that one footer item on the sheet. In Word I usually put file name, page of page, and the date, but I've not found out yet how to do that.
Reply With Quote
  #4  
Old 12-05-2013, 02:32 PM
macropod's Avatar
macropod macropod is online now How add 3 footer items to all sheets in workbook? Windows 7 32bit How add 3 footer items to all sheets in workbook? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

To select the multiple sheets, simply hold down the Shift or Ctrl key whilst clicking their tabs:
Shift lets you click on the first/last of a series and span all of them;
Ctrl lets you choose individual sheets to group for the action.

To add header/footer items in Excel, go to Page Setup>Header/Footer> Custom Header/Custom Footer and choose your Left, Center and Right content. Note too that you can have a different first page and different odd & even, just like in Word.

PS. Re:
Quote:
Northernmost Coast of California
I went through there in July this year, visiting Redwood N.P. & Crescent City.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How add 3 footer items to all sheets in workbook? #REF! error when opening a workbook that contain a refference to another workbook tanababa Excel 2 06-07-2012 03:11 PM
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? tinfanide Excel Programming 1 02-09-2012 04:08 PM
How add 3 footer items to all sheets in workbook? Combining 2 workbooks into 1 workbook with TWO sheets dguenther Excel 1 10-06-2011 03:25 AM
Linking sheets to fetch transactions from sheets to another waqer Excel 4 09-01-2011 12:35 PM
How add 3 footer items to all sheets in workbook? How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft