logo ASAP Utilities
HomeExtra features for ExcelColumns & RowsFix Autofit Row Height with Merged Cells and Hidden Columns

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu
Trustpilot

Fix Autofit Row Height with Merged Cells and Hidden Columns

ASAP Utilities  › Columns & Rows  ›  14. Fix Autofit Row Height with Merged Cells and Hidden Columns

This tool fixes the row height in your selected cells so the full content is visible for reading or printing, even when merged cells are used. Compared to Excel's built-in AutoFit Row Height, this tool:
  • Works on merged cells with wrap text enabled (Excel often fails to adjust these correctly)
  • Ignores hidden columns when calculating row height, so only visible content is used Excel's AutoFit does not work with merged cells and includes values from hidden columns when calculating the row height, which can result in rows that are too short or unnecessarily tall.
    This  tool avoids those issues by correctly adjusting the height for merged cells and basing it only on the content in visible cells, giving you cleaner and more accurate layouts. Note:
    Like Excel's AutoFit, this tool does not update row height automatically when content changes.
    If you edit the cell contents later, run the tool again to update the height.

    Screenshots

    Columns & Rows  ›  14 Fix Autofit Row Height with Merged Cells and Hidden Columns
    ASAP Utilities makes YOU rock in Excel!

    Practical tricks on how this can help you

    Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

    Starting this tool


    Columns & Rows  ›  14 Fix Autofit Row Height with Merged Cells and Hidden Columns
    Additional keywords for this tool:
    autofit row height, fix row height Excel, merged cells row height, Excel autofit not working, adjust row height, Excel wrap text row height, autofit merged cells, ignore hidden columns, Excel row height problem, fix wrapped text height, adjust merged cell row height
    Trustpilot
    Download  



    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.