Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Hi Patrick,
Thank you for your question.
If you go to Tools, Macro and then Record New Macro. Then View Header and Footer and type in the relevant information.
Then stop recording the macro by using the Stop Recording toolbar.
I hope this answers your question.
Regards
Simon
Fri 7 Aug 2009: Automatically marked as resolved.
When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.
After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 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.
