Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Feb 2004
    Location
    Minnesota, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Expanding Cells (Excel 2000 9.0.38)

    Good morning, folks. I am a newbie here.

    Would love some help with a problem that I just can't seem to find the answer to in my books. Is there a way, as I am entering data, to have the row height expand to fit the data I am entering. I would like the column width to remain the same, but I would appreciate being able to see all the data entered into a cell by having the cell height expand.

    Any way for Excell to do this automatically?

    Thanks for all your help.

    TD3

  2. #2
    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: Expanding Cells (Excel 2000 9.0.38)

    select the cells
    Format - cells - Alignment(tab)
    check "Wrap text"

    Steve

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

    Re: Expanding Cells (Excel 2000 9.0.38)

    I don't know if it works in Excel 2000, but in Excel 2002 (aka XP), this works more or less of you tick "Wrap text" in the Alignment tab of Format | Cells... Excel is not perfect at this, though, it is not a word processing application. You may end up with extra blank space in the cell, and the way the text wraps in a printout may be different from the on-screen display.

  4. #4
    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: Expanding Cells (Excel 2000 9.0.38)

    Even in the ancient workings of XL97, we are able to do this <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Steve

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

    Re: Expanding Cells (Excel 2000 9.0.38)

    I thought so too, but it's dangerous to rely on memory where it concerns previous versions of software (well, for me it's dangerous to rely on memory for anything, but that's another story <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>). Thanks for confirming this.

  6. #6
    New Lounger
    Join Date
    Feb 2004
    Location
    Minnesota, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expanding Cells (Excel 2000 9.0.38)

    Thanks for the help. I have Wrap Text already enabled in Format and still could not see all the data I had in the cells. Perhaps I did it wrong. I'll try selecting the cells and then try wrapping again.

    TD3

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expanding Cells (Excel 2000 9.0.38)

    How much data do you have in the cell, and how tall is the cell already? Even though you can enter 32k characters into a cell, Excel will only display about 1k of the characters. The maximum height of a cell is 409.50, so if the cell is that height it will not grow any taller.
    Legare Coleman

  8. #8
    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: Expanding Cells (Excel 2000 9.0.38)

    Also merged cells will not change height automatically.

    Check out <post#=270923>post 270923</post#> for some code as a workaround if this is an issue.

    Steve

  9. #9
    New Lounger
    Join Date
    Feb 2004
    Location
    Minnesota, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expanding Cells (Excel 2000 9.0.38)

    THAT'S IT!

    Ha, I knew there had to be a reason the silly rows would not expand. Whoever set up this spreadsheet had combined columns.

    Thanks, y'all. You have saved the day.

    TD3

Posting Permissions

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