+ Reply to Thread
Results 1 to 3 of 3

Excel Headers & Footers

  1. #1
    Registered User
    Join Date
    10-16-2008
    Location
    Pasco, WA
    Posts
    2

    Excel Headers & Footers

    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

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,866

    Smile

    Good evening rkohlbeck

    ...and welcome to the forum!!
    Quote Originally Posted by rkohlbeck View Post
    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 ... ?

    Quote Originally Posted by rkohlbeck View Post
    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.

    Quote Originally Posted by rkohlbeck View Post
    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
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    10-16-2008
    Location
    Pasco, WA
    Posts
    2

    Thank you Dominic

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filter external data based on value in Excel?
    By obiwaynekenobi in forum Excel General
    Replies: 1
    Last Post: 01-24-2008, 11:55 PM
  2. Excel Macro - Read excel & read excel range - save as text
    By se.sathish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2008, 09:00 AM
  3. Excel 2007 file save problems
    By JVD in forum Excel General
    Replies: 1
    Last Post: 01-15-2008, 04:48 PM
  4. processing a string by Excel
    By mark_neil2 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-20-2007, 07:35 AM
  5. how to merge data from one excel into another excel
    By refreshplease3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2006, 08:51 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1