Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell Formatting (2003)

    A user has a simple 3 column spreadsheet, columns A, B and C. Column B is formatted for text. However, on certain cells, the line spacing appears as double space for no apparent reason. I've attached a screen shot. I've checked all the usual suspects (cell formattingalignmentjustifications, etc) and cannot determine why only certain cells appear to be double space. Anyone have a clue?
    Attached Images Attached Images

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

    Re: Cell Formatting (2003)

    Are you sure that vertical alignment hasn't been set to Justify or Distributed?

  3. #3
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Formatting (2003)

    Cell alignment is Justify in all cells. The cell above the problem cell in my attachment is set for justify also. If I change the alignment in the problem cell, say to Top, then I have extra space at the bottom of the cell. It's acting very strange. Here's another screen shot.
    Attached Images Attached Images

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

    Re: Cell Formatting (2003)

    There is more text in the top cell of the screenshot, so it takes up 5 lines, whereas the text in the bottom cell takes up 4 lines. Unfortunately, Excel is not very good at handling wrapped text, it frequently miscalculates the row height, even if you select AutoFit. You'll have to resort to adjusting row heights manually in many cases.

  5. #5
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Formatting (2003)

    If it's just a matter of readjusting the row height, then I can live with that. Too bad we're 7,000 miles apart - I owe you a few beers! Thanks Hans

  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: Cell Formatting (2003)

    Be careful if you go to print it and adjust the row ht. Some of the time, the "miscalculation" is on the screen display, but it is calcuated correctly for the printout. The printout may require the extra width as it may be wrapped differently due to different resolutions from display to printout.

    What you see is not always what you get.... [Check the print Preview in some of these cases to see the printer driver is "setting" some of the row ht...]

    Steve

  7. #7
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Formatting (2003)

    That's interesting - I'll check it now. Thanks.

Posting Permissions

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