Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Headers / footers in Excel
Hello there
This drives me mad.... how can I automatically repeat a header or footer into each worksheet of an Excel workbook? Somebody please help!! I currently go in and manually change each one, which is a real pain, when I want exactly the same header/footer in each worksheet. Any advice gratefully received! Thanks. |
#2
|
|||
|
|||
Hi
select all required sheets (hold down the CTRL key while doing this). After this apply your header/footer -- Regards Frank Kabel Frankfurt, Germany "Airbags" schrieb im Newsbeitrag ... Hello there This drives me mad.... how can I automatically repeat a header or footer into each worksheet of an Excel workbook? Somebody please help!! I currently go in and manually change each one, which is a real pain, when I want exactly the same header/footer in each worksheet. Any advice gratefully received! Thanks. |
#3
|
|||
|
|||
Hi Frank
Thank you so much for the quick reply - you've saved a (usually intelligent) girl from a lot of frustration! Many thanks Mo "Frank Kabel" wrote: Hi select all required sheets (hold down the CTRL key while doing this). After this apply your header/footer -- Regards Frank Kabel Frankfurt, Germany "Airbags" schrieb im Newsbeitrag ... Hello there This drives me mad.... how can I automatically repeat a header or footer into each worksheet of an Excel workbook? Somebody please help!! I currently go in and manually change each one, which is a real pain, when I want exactly the same header/footer in each worksheet. Any advice gratefully received! Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Headers while scrolling down | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) |