Macros

Resolved · Low Priority · Version 2003

Wed 29 Jul 2009, 16:58 Delegate Patrick D said...

Patrick D has attended:
Excel Advanced course

Macros

How do I create Marcos for a header and footer?

Fri 31 Jul 2009, 11:58 Trainer Simon said...

RE: 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.

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

Macros

Macros

RE: Macros

Excel articles

Excel tip:

Closing Multiple Workbooks quickly