1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Excel column issue

Discussion in 'HTML & Website Design' started by fadetoblack22, May 8, 2017.

  1. #1
    I have a simple excel spreadsheet with columns of text.
    SEMrush
    The title of the first column is too large for the cell and it means that the next column has to start too far over.

    I can't increase the column width because it will change the data layout above these rows.

    Is there anything I can do about it to allow the column to be slightly wider without affecting what's above? I've looked at merging the cells, but I don't think that will work as then I'll have to change the width of the next column over.
     

    Attached Files:

    fadetoblack22, May 8, 2017 IP
    SEMrush
  2. kk5st

    kk5st Prominent Member

    Messages:
    3,487
    Likes Received:
    368
    Best Answers:
    28
    Trophy Points:
    335
    #2
    Break your header into two rows.
     
    kk5st, May 8, 2017 IP
  3. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,630
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    #3
    It seems that you only have one element in a two-column wide set - can't you just join the two cells from that heading down?
     
    PoPSiCLe, May 8, 2017 IP
  4. hubblefrog

    hubblefrog Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #4
    Select all your long text then click wrap text.
    Excel menu.PNG
     
    hubblefrog, May 8, 2017 IP
  5. fadetoblack22

    fadetoblack22 Well-Known Member

    Messages:
    2,327
    Likes Received:
    51
    Best Answers:
    0
    Trophy Points:
    160
    #5
    Sorry guys, there's more text above what's in the screenshot, so joining the cells and reducing the column size will mess up what's above.
     
    fadetoblack22, May 8, 2017 IP
  6. kk5st

    kk5st Prominent Member

    Messages:
    3,487
    Likes Received:
    368
    Best Answers:
    28
    Trophy Points:
    335
    #6
    Did you not read the posts from @hubblefrog or myself?

    gary
     
    kk5st, May 9, 2017 IP
  7. fadetoblack22

    fadetoblack22 Well-Known Member

    Messages:
    2,327
    Likes Received:
    51
    Best Answers:
    0
    Trophy Points:
    160
    #7
    I did. I'd misunderstood it. I think wrapping the text may be a solution!
     
    fadetoblack22, May 9, 2017 IP
  8. deathshadow

    deathshadow Acclaimed Member

    Messages:
    9,149
    Likes Received:
    1,705
    Best Answers:
    239
    Trophy Points:
    515
    #8
    Silly question, but what the **** does this have to do with HTML or web design?
     
    deathshadow, May 9, 2017 IP
  9. fadetoblack22

    fadetoblack22 Well-Known Member

    Messages:
    2,327
    Likes Received:
    51
    Best Answers:
    0
    Trophy Points:
    160
    #9
    It's going on my website :) Joke.
    I just couldn't find a suitable section for it.
     
    fadetoblack22, May 10, 2017 IP