Excel Headers & Footers

**rkohlbeck** · 10-16-2008, 04:22 PM

I have three questions and I am hoping I haven't reached limitations of Excel.
1. I am setting up custom headers and footers on my worksheet. Is there anyway to adjust the space to the left of the left Header & footer and to the right of the right header and footer? Even with my margins set for .25 around the outside edge, if moves the left header in to about .7 or so and same from the right edge.
2. In my custom footer, is there any way to get around the 255 character limit in the center footer? I am trying to fit in a disclaimer and we all know how long disclaimers can be!
3. I would like to put a File Created date in my custom footer on the left. Not a modified or updated field, does anyone know the code I would need to do this?

If there are no answers to these I guess I could just not use the custom header and footer options and hardcode this stuff in the worksheet. But I thought I would ask the gurus first!

Thanks you for your help,
Excel Novice
Ryan Kohlbeck

**dominicb** · 10-16-2008, 05:42 PM

Good evening rkohlbeck

...and welcome to the forum!!

Originally Posted by rkohlbeck

1. I am setting up custom headers and footers on my worksheet. Is there anyway to adjust the space to the left of the left Header & footer and to the right of the right header and footer? Even with my margins set for .25 around the outside edge, if moves the left header in to about .7 or so and same from the right edge.

I'm not sure, but I imagine your printer has limits as to how close it can print to the edge - this would be defined by your driver and Excel can't override this. Get an edge-to-edge orinter ... ?

Originally Posted by rkohlbeck

2. In my custom footer, is there any way to get around the 255 character limit in the center footer? I am trying to fit in a disclaimer and we all know how long disclaimers can be!

Can you do your document in Word? That can handle more than 255 characters. Or send the paper through the printer from Word, then print over the top from Excel? Or capture the text you want as an image and use the image as a footer?
Not very good suggestions, I know, but it's the only way you can achieve what you need to do.

Originally Posted by rkohlbeck

3. I would like to put a File Created date in my custom footer on the left. Not a modified or updated field, does anyone know the code I would need to do this?

Please Login or Register  to view this content.

It's event code so it needs to go into your ThisWorkbook module.

HTH

DominicB

**rkohlbeck** · 11-14-2008, 08:47 PM

Sorry for the long return! I have been busy and finally got back to this project. Well, we are off to a good start. Considering my posts:

1. This is not a printer print area issue. I have a .25" left margin, then a blank column then my spreadsheet. I defined the print area to include the blank column on the left for spacing. Excel is pushing the left header and footer in from the left .3 or .4 inches.

2. The picture idea worked, although it is a pain to work that way, considering text takes much smaller space than pixels!

3. The VB worked excellent. However how would I include precursor text in that area as well. For example if I wanted "Creation Date: " before the date it inserted?

So far, thank you for your help.