Home Screenshots 10 Languages Why use it?

Tip of the Day | Saturday March 28th, 2026

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

Unwrap Text in Selected Cells

This tool turns off text wrapping in the selected cells, so all content appears on a single line, even if the text is long or contains manual line breaks.

This is useful when:

Restoring a clean, single-line layout

Fixing layout issues caused by multi-line cells

Preparing data for export or systems that require unwrapped text

Unlike Excel's built-in Wrap Text button, which toggles wrapping based on the active cell in your selection, this tool always turns off wrapping regardless of which cell is active. This makes it more predictable and saves time, especially when working with mixed-format selections.
Another 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.

Historical Note:
ASAP Utilities introduced this in 1999, years before Excel added a "Wrap Text" button to the ribbon in Excel 2007. Until then, it could only be set via the cell's formatting properties (Format > Format Cells > Alignment > Wrap Text).

Starting this tool

Click ASAP Utilities › Format & Layout › 8. Unwrap Text in Selected Cells
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Format & Layout › Unwrap Text in Selected Cells

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.