Results 1 to 7 of 7
  1. #1
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Custom Header Alignment (Excel 2000 SR-1)

    I am confused or things are different with headers in XL97 vs XL2000.
    The left header is left aligned, the center is centered, and the right is right-aligned. The alignment deals with the whole sheet, since there is not a section for each:
    The Headers can overlap each other.

    So If you want to right align the left header, why not just make it the right header?

    Steve

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Custom Header Alignment (Excel 2000 SR-1)

    It's still the same in Excel 2002, Steve.

  3. #3
    New Lounger
    Join Date
    Nov 2003
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Custom Header Alignment (Excel 2000 SR-1)

    Can you change the alignment of the right, center, or left custom header? I have part of the header in the right cell and it is right justified. I would like to move it left. Options seem limited in custom headers.

  4. #4
    New Lounger
    Join Date
    Dec 2002
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Custom Header Alignment (Excel 2000 SR-1)

    I think what she meant was how do you justify something other than left, center or right. Let's say you want to put the footer 2" from the right side of the page but you want your data to be justified 1" left and right. Is that possible to do, I don't know that answer.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel Custom Header Alignment (Excel 2000 SR-1)

    It's crude, but you can put in hard spaces (Ctrl-Shift-Space) before or after the text, according to if it the left or right header or footer. I haven't figured out how to enter a tab manually, but it may be possible programatically.
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Custom Header Alignment (Excel 2000 SR-1)

    Margins are set. You can "spaces". I usually use <alt>0160 which is a "sticky-space". Excel sometimes ignores regular spaces in formatting when at the end or beginning of a string. If you are going to attach it with code, concatenate with chr(160).

    <pre>with activesheet.pagesetup
    .RightHeader = .Rightheader & application.worksheetfunction.rept(chr(160),12)
    end with</pre>


    to add 12 spaces after the right header or to move the left header

    <pre>with activesheet.pagesetup
    .LeftHeader = application.worksheetfunction.rept(chr(160),12) & .LeftHeader
    end with </pre>


    The number of spaces needed to get a certain number of inches will depend on font and fontsize and will most likely be determined by trial -and-error

    Steve

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Custom Header Alignment (Excel 2000 SR-1)

    In code you can use chr(9), but I couldn't get <alt>0009 to work manually. I did get it to work by using =char(9) in an excel cell and then copying the contents to clipboard and pasting it into the header

    Steve

Posting Permissions

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