+ Reply to Thread
Results 1 to 2 of 2

AutoFit Row Height for merged cells

  1. #1
    Forum Contributor
    Join Date
    07-26-2012
    Location
    USA
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    351

    AutoFit Row Height for merged cells

    First, I know you can't autofit row height on merged cells. I also know wrapping text won't autofit the row height if you've manually adjusted the height, and I can't use this method anyways since my cells HAVE to be merged. With that said, I have 8 rows that I need to autofit. The cells in each row are merged. So I have A1:H1, A2:H2, etc, A1:H1 being merged into 1 cell, and so on. The length of the text will vary extensively from row to row, so I need to wrap it and then autofit the row height. However, it appears this is pretty much impossible. Does anyone have any ideas? Been tinkering with this for a while and having no luck
    Last edited by VBA FTW; 01-03-2014 at 03:43 PM.

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: AutoFit Row Height for merged cells

    I tend to avoid Merged Cells wherever I can. I prefer Centre Across Selection. Would this work in your situation?


    When you reply please make it clear WHO you are responding to by mentioning their name.
    If this has been of assistance, please advise. A little thanks goes a long way.
    - Please click on the *Add Reputation button at the bottom of helpful responses.
    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

+ 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] Autofit Row Height on Merged Cells
    By Dragman in forum Excel General
    Replies: 0
    Last Post: 11-08-2013, 03:16 PM
  2. Automatic row height after text entered into wrapped and merged cells
    By SteveRea in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2013, 03:00 PM
  3. Autofit a row of merged cells that have wrapped text.
    By avidcat in forum Excel General
    Replies: 3
    Last Post: 11-13-2009, 08:41 AM
  4. Replies: 3
    Last Post: 05-22-2005, 08:06 PM
  5. Autofit of Row Height with Merged Cells - AGAIN!
    By Paige in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-14-2005, 03:06 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