![]() |
#1
|
|||
|
|||
![]() 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. |
#2
|
||||
|
||||
![]()
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] |
#3
|
|||
|
|||
![]()
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.
|
#4
|
||||
|
||||
![]()
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:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
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 |
![]() |
nolesca | Excel | 4 | 06-07-2010 08:13 AM |