Home |
Search |
Today's Posts |
#1
|
|||
|
|||
customised header and footer
I want to save a header and footer that I have customised to use on more than
one excel sheet. It seems I have to keep typing it all, Help please |
#2
|
|||
|
|||
Hi Annette, try this:
To create the same header or footer on all sheets in an Excel workbook without having to set up the header or footer on each sheet individually, you need to first group the sheets. To group sheets click on the first sheet you want in the group, then hold your SHIFT key and click the last sheet you want to include in the group. Any sheets in between the first and last sheet will be included in the group. Then set up your header or footer, and all sheets in the group will have the same header or footer. To ungroup the sheets when you've finished, right-click on any sheet in the group and click "Ungroup sheets." "Annette" wrote: I want to save a header and footer that I have customised to use on more than one excel sheet. It seems I have to keep typing it all, Help please |
#3
|
|||
|
|||
save file as a template type
"Annette" wrote: I want to save a header and footer that I have customised to use on more than one excel sheet. It seems I have to keep typing it all, Help please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Give multiple charts on a worksheet/workbook same header or footer | Excel Discussion (Misc queries) | |||
Give multiple charts on a worksheet/workbook same header or footer | Charts and Charting in Excel | |||
How do I hide the header and footer on page 1 in Excel? | Excel Discussion (Misc queries) | |||
Custom Header and Footer | Excel Discussion (Misc queries) | |||
How to insert a picture in the Footer (not the Header) in Excel 20 | Excel Worksheet Functions |