logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Unwrap Text in Selected Cells

ASAP Utilities  › Format & Layout  ›  8. 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


    Format & Layout  ›  8 Unwrap Text in Selected Cells
    Additional keywords for this tool:
    Remove text wrapping, Turn off wrap text, Unwrap wrapped text, Show all text on one line, Disable wrap text, Fix multi-line cells, Convert wrapped text to single line, Single-line text cells, Remove line breaks display, Formatting undo wrap text, Undo wrap text, Flatten Excel cell text, Remove manual line breaks visually, Force text to one line, Unwrap cell contents, Cell formatting wrap off, Shortcut to unwrap text in Excel



  • 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.