| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
xls header all sheets
How do I apply a header and footer in excel to all of the sheets in the
workbook without manualy retyping them into each sheet? |
|
#2
|
|||
|
|||
|
BullyBear, group the sheets, right click on a sheet tab and select all
sheets, change the header, then ungroup the sheets -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "BullvBear" wrote in message ... How do I apply a header and footer in excel to all of the sheets in the workbook without manualy retyping them into each sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Header or Footer to show up on multiple sheets in a document | Excel Worksheet Functions | |||
| Add images or logos to the Header in Ms- Excel Sheets | Excel Worksheet Functions | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
Linear Mode
