Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Automatically Adjust Row Height (2000)

    Whenever I type text into a cell that wraps (or I manually format it to wrap), I always have to go back and manually increase the height of the row so that all of the text is visible. Any way I can set the default settings to do this automatically, or is there some code that I can run to do this "globally"?
    Thanks.

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

    Re: Automatically Adjust Row Height (2000)

    Are you doing this in merged cells? Excel will (or should) automatically adjust the height of rows with text wrapping turned on if there are no merged cells. The thread starting at <post#=270876>post 270876</post#> contains various macros to adjust the row height if there are merged cells.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Automatically Adjust Row Height (2000)

    Thanks, Hans, and yes, I am talking about mergged cells...

Posting Permissions

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