Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Headers and footers
Resolved · Medium Priority · Version 2003
Liz has attended:
SharePoint course
how can I enter headers and footers throughout a whole workbook please?
Hi Liz,
Thank you for your question.
If you select your first sheet tab, hold the shift key down and then with the shift key still held down, click on the last tab. The document is now in Group mode.
Navigate to the Headers and Footers and insert the desired information.
Then ungroup the sheets by clicking on one of the other sheets that are not bold and make sure the Group text is removed from the title bar at the top of the screen.
I hope this answers your question.
Regards
Simon
|
Excel tip:Reset Excel toolbars to default settingsIf you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults. |
We'll call during UK business hours
Server loaded in 0.09 secs.