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

Additional keywords to help you find 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

Tip:Alt+P for the previous tool.