Tip of the Day | Thursday February 19th, 2026

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

Unmerge Selected Cells

This tool unmerges all merged cells in your current selection.

This is useful when:

Cleaning up imported or formatted data

Preparing data for sorting or filtering

Restoring a consistent, grid-based layout

It works similarly to Excel's "Merge & Center" button, which toggles merging on and off or the "Unmerge Cells" option in its dropdown.
The benefit of having this tool in ASAP Utilities is that you can assign a shortcut to it via 'My Tools & Shortcut Keys' for accessibility and even faster access.

Why unmerge?
Merged cells can cause issues with sorting, filtering, and selecting ranges. They're often discouraged in structured datasets because they break Excel's row and column logic.

Tip:
Instead of merging, consider using our "Center Horizontally Across Selection Without Merging" tool or Excel's Center Across Selection option in the Format Cells > Alignment settings. It visually centers text horizontally without merging cells, making your data easier to work with.

Starting this tool

Click ASAP Utilities › Format & Layout › 14. Unmerge Selected Cells
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Format & Layout › Unmerge Selected Cells

Choose your language preference below

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

Yesterday's Tip

Tomorrow'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.