|
|
|
|
#1
12-04-2013, 06:15 PM
|
||||
|
||||
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] 
|
|
#2
12-05-2013, 11:06 AM
|
|||
|
|||
|
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.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 #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 |
|
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 do I merge data from one sheet in a workbook out into multiple sheets
|
nolesca | Excel | 4 | 06-07-2010 08:13 AM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode