training microsoft excel - headerfooter

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Header/Footer

training microsoft excel - Header/Footer

resolvedResolved · Low Priority · Version Standard

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

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

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

Edited on Fri 17 Aug 2007, 11:37

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

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


 

Excel tip:

Use RANDBETWEEN to generate random numbers

There 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.

The function looks like this:

=randbetween(LOW,HIGH)

where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.

This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:

=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).

where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).

One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.

View all Excel hints and tips


Server loaded in 0.08 secs.