+ Reply to Thread
Results 1 to 3 of 3

Auto Adjust Row Height

  1. #1
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    316

    Auto Adjust Row Height

    I'm working on a spreadsheet that would like to add an auto adjust row height to but my problem is that I have merged several cells, therefore the command isn't working. As far as I know, that command will only work with non-merged cells.

    Is it possible to have a macro do this trick for me on the particular cells that I want to assign it to? Then, maybe I could just add a button to do all the cells at once?

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Auto Adjust Row Height

    The row height should adjust itself automatically when you hit Enter after entering a cell value. I don't know why a macro would be needed.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

  3. #3
    Registered User
    Join Date
    05-06-2014
    Location
    Cali or philly
    MS-Off Ver
    Excel 2003
    Posts
    60

    Re: Auto Adjust Row Height

    Select the top left cell to select all and double click the row height to auto adjust

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto adjust height in a cell
    By Treecko in forum Excel General
    Replies: 4
    Last Post: 12-19-2013, 08:51 PM
  2. [SOLVED] Macro to auto adjust row height
    By Unnati in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-25-2012, 07:07 AM
  3. Excel 2007 : Auto-adjust row height on VLOOKUP?
    By cornishdave in forum Excel General
    Replies: 6
    Last Post: 07-03-2012, 09:34 AM
  4. Setting Row Height Along with Auto Adjust
    By lwolsiffer in forum Excel General
    Replies: 0
    Last Post: 11-03-2010, 04:53 PM
  5. auto adjust row height
    By maacmaac in forum Excel General
    Replies: 2
    Last Post: 03-14-2007, 05:54 PM

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