+ Reply to Thread
Results 1 to 8 of 8

Formatting to automatically expand row height

  1. #1
    Registered User
    Join Date
    02-20-2009
    Location
    Mounds View, MN
    MS-Off Ver
    Excel 2007
    Posts
    7

    Formatting to automatically expand row height

    I'm using the wrap format on a cell, but it only automatically expands the row height so far. After a certain point of typing in the cell I find that in order to show all the contents, I need to expand the row height automatically. I need this to work with Excel 97-2003.
    Any ideas? Sometimes the simplest things are the most frustrating!
    Jeanette

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formatting to automatically expand row height

    format /row / autofit
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    02-20-2009
    Location
    Mounds View, MN
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Formatting to automatically expand row height

    Is there a character limit on this? It only seems to automatically expand to a certain point.

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formatting to automatically expand row height

    make sure cell formatted general

  5. #5
    Registered User
    Join Date
    02-20-2009
    Location
    Mounds View, MN
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Formatting to automatically expand row height

    Still not expanding even with the general formatting.
    Attached Files Attached Files

  6. #6
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formatting to automatically expand row height

    not sur coz i thought max was 1024 but i can stretch it out to see more hmmmmm!
    Last edited by martindwilson; 07-30-2009 at 03:55 PM.

  7. #7
    Registered User
    Join Date
    02-20-2009
    Location
    Mounds View, MN
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Formatting to automatically expand row height

    Looks like I can only do 1146 characters. Anything after that and it will not expand.

  8. #8
    Registered User
    Join Date
    05-17-2012
    Location
    henderson, nv
    MS-Off Ver
    excel 2007
    Posts
    2

    Re: Formatting to automatically expand row height

    Quote Originally Posted by jholmstrom21 View Post
    I'm using the wrap format on a cell, but it only automatically expands the row height so far. After a certain point of typing in the cell I find that in order to show all the contents, I need to expand the row height automatically. I need this to work with Excel 97-2003.
    Any ideas? Sometimes the simplest things are the most frustrating!
    Jeanette
    I believe this will answer your question:
    for excel 2007:

    1. Select all rows you want to autofit
    2. goto the home tab on the ribbon
    3. In the "cells" block click the down arrow on format.
    4. Choose "autoFit Row Height"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1