Home Screenshots 10 Languages Why use it?

Tip of the Day | Monday May 18th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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 › Fix Autofit Row Height with Merged Cells and Hidden Columns

Starting this tool

Click ASAP Utilities › Columns & Rows › 14. Fix Autofit Row Height with Merged Cells and Hidden Columns
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Today's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

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