Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Header/Footer
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
training microsoft excel - Header/Footer
Resolved · Low Priority · Version Standard
Reply Wed 15 Aug 2007, 16:12Delegate Fazil said...
Fazil has attended:
Excel Advanced course
Header/Footer
Hello,
I need to create different worksheets for my reporting and everytime I do so, while printing I had to type my standard header everytime. How do I make my standard (created by me) footer appear in the 'custom header' so that I dont have to type every time.
Regards... Fazil
For upcoming training course dates see: Pricing & availability
RE: Header/Footer
Hi Fazil,
Thanks for the question. If you have to do a repeated action you can always record a macro to do the action for you and then you would just need to run the macro and the custom header would be put in place.
How you would do this is:-
1) Click Tools -> Macro -> Record a New Macro
Call it a relevant name and in this dialog box make sure you save the Macro in your Personal Macro Workbook, this means you can use it in a different workbook. You can also assign a keyboard shortcut to it.
2) Click OK and make sure the button next to the recording is depressed. (important step this)
3) Then go through the standard procedure of setting your Custom Header in the Page Setup section.
4) Finish recording.
5) You have recorded a macro to do that procedure and you can allocate that task to a button if you wish.
regards
Tracy
Reply Fri 17 Aug 2007, 11:13Delegate Fazil said...
RE: Header/Footer
Thanks a lot Tracy. I just tried and it worked. It is very helpful, going to make my life a bit more easier.
Have a nice weeke-end.
Regards... Fazil
RE: Header/Footer
I was going to go on and show you how to allocate the Macro to a button, would that help?
Simply go to the toolbar buttons, right-click, and choose the option Customise and then you get the Customise dialog box up.
From there choose the Commands Tab, down to Macro and from the right hand side drag a custom button up on to your toolbar between two existing buttons.
Then once its there right click over it, (With the customise dialog box still open) and go to the option Assign Macro and you can pick your header macro that you have just created.
Close down the Customise Dialog box
Then all you need to do is click a button to perform your Macro
Ta Dah ....!!
Have a good weekend
Trace
Reply Fri 17 Aug 2007, 12:03Delegate Fazil said...
RE: Header/Footer
Hi Tracy,
I dont know how to thank you for this...! This is just amazing..! A very special thanks to you...!
Regards... Fazil
|