98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Header/Footer
training microsoft excel - Header/Footer
Resolved · Low Priority · Version Standard
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
Fri 17 Aug 2007, 10:31Trainer Tracy said...
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
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
Fri 17 Aug 2007, 11:27
Edited on Fri 17 Aug 2007, 11:37Trainer Tracy said...
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
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. |
Excel tip:Use RANDBETWEEN to generate random numbersThere may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify. |
