1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multi-line header not justifying all lines

Discussion in 'Ask an Excel Question' started by Hank Moore, Mar 4, 2019.

  1. Hank Moore

    Hank Moore New Member

    Messages:
    29
    despite everything i try, I cannot get the top line of my header to left justify to match the 2nd line. Any suggestions?

    Thank you

    Attached Files:

  2. Eloise T

    Eloise T Active Member

    Messages:
    867
    Are you referring to the [Invoice] tab, cells K2 thru K4?

    Attached Files:

  3. Hank Moore

    Hank Moore New Member

    Messages:
    29
    I'm sorry, I should have been more descriptive.... If you look at the print preview of the Proposal tab, you'll see the header "1Solution' left justified to match the tag line underneath it.
    If you look at the Invoice tab you'll see how "1Solution" does not line up.
    I've uploaded a revised copy of the file so the names match

    Attached Files:

  4. Eloise T

    Eloise T Active Member

    Messages:
    867
    I'm going to need a specific cell reference.
    When I did a search on "1Solution" with FIND, it only came up with the e-mail address in Tab [Invoice], Cell F23.
  5. Hank Moore

    Hank Moore New Member

    Messages:
    29
    It's in the header. what is the cell reference for a header?
  6. Fluff13

    Fluff13 Member

    Messages:
    40
    On the proposal sheet you have a number of spaces before the tag line, which are not there on the invoice sheet
  7. vletm

    vletm Excel Ninja

    Messages:
    4,918
    Hank Moore
    The second line (with smaller font) of headers are different,
    that's why those are not align same way.
  8. Hank Moore

    Hank Moore New Member

    Messages:
    29
    would it not be possible for you to go to Page Layout>Margins>Custom Margins>Header/Footer>Customer Header?
  9. Hank Moore

    Hank Moore New Member

    Messages:
    29
    Let me try that Fluff
  10. vletm

    vletm Excel Ninja

    Messages:
    4,918
  11. Hank Moore

    Hank Moore New Member

    Messages:
    29
    The fact that the two lines are of different font wouldn't affect how they justify to the left would it? Also, the document keeps adding spaces to the front of the top line no matter how many times I remove them. And the link of formatting codes that vietm sent me doesn't seem to work (unless I'm not using it properly)
  12. Hank Moore

    Hank Moore New Member

    Messages:
    29
    fluff, I added the spaces in front of the second line just as a work-around to get the two lines to even up with each other but I'd really like to get the 1st line to left justify so it doesn't run so far over to the right
  13. Fluff13

    Fluff13 Member

    Messages:
    40
    The first line also has a space in front, but you say you cannot get rid of it.
    Also the Italic font will make it look as though it's not fully justified left
  14. Hank Moore

    Hank Moore New Member

    Messages:
    29
    Correct. The space (or spaces) keep returning and if I change the font size of the space(s), they return to the larger size as well.
    Changing the font from italic to regular does not fix it nor does changing the font to something plain like arial.
    It's only the Invoice worksheet - I don't have this issue with the Proposal worksheet.
  15. Hank Moore

    Hank Moore New Member

    Messages:
    29
    revised workbook with font changed to arial regular. no italics, no bold

    Attached Files:

  16. Eloise T

    Eloise T Active Member

    Messages:
    867
    Hank,
    Would you mind reiterating exactly what you're still having a problem with on the Invoice sheet. Please give Cell references. Please also do the same for the Proposal sheet indicating what is working that is not working on the Invoice sheet.
  17. vletm

    vletm Excel Ninja

    Messages:
    4,918
    for Eloise T
    This is his challenge:
    Multi-line header not justifying all lines - no cell reference!

    Screenshot 2019-03-08 at 09.08.51.png
  18. deciog

    deciog Active Member

    Messages:
    128
    Hank More

    Check if this is what you want

    Decio

    Attached Files:

  19. Eloise T

    Eloise T Active Member

    Messages:
    867
    The "1" in 1 Solution (Copperplate Gothic Light) takes up for sake of argument 20 mm horizontally using 60 font size while the line below is using approx. 3 mm per character horizontally (Trebuchet MS) using font size 11. The "blocks" of space that each character in each line is using is not equal. The "fix" as I can see it is to left justify the "1 Solution" line and pad the beginnin of the second line with spaces to line up with the line above it. Will that not work?

Share This Page