+ Reply to Thread
Results 1 to 5 of 5

Autofit cells that have formulas in them, to fit TEXT

  1. #1
    Registered User
    Join Date
    08-22-2019
    Location
    Edmonton, Canada
    MS-Off Ver
    Version 1809
    Posts
    18

    Autofit cells that have formulas in them, to fit TEXT

    I'm having issues being able to autofit my cells. I have concat and if statements in them. The text is usually longer than the actual formula.

    However, any traditional means of "autofit" does not work so was wondering if there is some other way to "autofit" without having to manually size each cell accordingly.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Autofit cells that have formulas in them, to fit TEXT

    you mean apart from highlighting the whole column then double clicking on the right side of the column?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    08-22-2019
    Location
    Edmonton, Canada
    MS-Off Ver
    Version 1809
    Posts
    18

    Re: Autofit cells that have formulas in them, to fit TEXT

    Yes, because it's 2 columns merged together. It's not the width I want to change, it's the length of the row (which also merged cells within the row).

    This particular cell would be D13:E13

  4. #4
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: Autofit cells that have formulas in them, to fit TEXT

    Seem auto-fit can not work with merged cells.
    You may require to do one of the following.
    1. Cancel all merged cells (in columns) then you can use auto-fit.
    2. Use VBA to calculate maximum width (in points) and set width of each column eventually.

    Regards.

  5. #5
    Registered User
    Join Date
    08-22-2019
    Location
    Edmonton, Canada
    MS-Off Ver
    Version 1809
    Posts
    18

    Re: Autofit cells that have formulas in them, to fit TEXT

    Thanks! I was able to re-format my sheet to un-merge the applicable cells.

    Was going to attempt the VBA to calculate width but it was easier to do it the other way :p

+ 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] Can I determine the effect of autofit to .columnwidth prior to executing the autofit?
    By kadeo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-13-2016, 10:29 AM
  2. Concatenate a variable # of cells based on 1 criteria into a cell then autofit the text
    By DrummerAndy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2015, 12:05 PM
  3. [SOLVED] Wrap Text without Cells AutoFit(ting)?
    By EnigmaMatter in forum Excel General
    Replies: 4
    Last Post: 03-06-2014, 09:54 AM
  4. 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
  5. Autofit with Merged Cells/Wrap Text Macro Problem
    By elfmajesty in forum Excel General
    Replies: 3
    Last Post: 05-25-2006, 01:40 PM
  6. [SOLVED] Autofit in cells with multiple lines of wrapped text.
    By John Keith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2006, 03:10 PM
  7. RE: Autofit in cells with multiple lines of wrapped text.
    By John Keith in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2006, 11:35 AM

Tags for this Thread

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