How to unwrap text in Microsoft Excel

In Microsoft Excel, wrap text is a feature that allows text within a cell to be displayed on multiple lines, rather than being restricted to a single line that is cut off at the cell boundary. This feature can be particularly useful when dealing with long cell contents. If you have a long text string in a cell that is wider than the column width, wrapping the text allows you to display the entire text string without having to adjust the column width. By wrapping text, you can make it easier to read by breaking it up into smaller, more manageable chunks that fit within the cell boundaries.

In this tutorial we will learn how to unwrap text in Microsoft Excel. Unwrapping text in Excel is the process of reverting back to the default display setting where long text strings are displayed as a single line within a cell. Unwrapping text can be useful in cases where you want to view the entire text string without having to scroll through multiple lines or when you want to export the data to another system that doesn’t support wrapped text.

Method 1 : Unwrap the Text using Wrap Text Button

Step 1 – Select the Wrapped Text

  • Select the cell or multiple cells containing the wrapped text.

Step 2 – Go to the Home Tab 

  • Go to the Home tab in the menu bar.

Step 3 – Click on the Wrap Text Button

  • Click on the Wrap Text button in the alignment section.
  • The text will be unwrapped.

Method 2 : Unwrap the Text using Format Cells Option

Step 1 – Select the Wrapped Text

  • Select the cell or multiple cells containing the wrapped text.

Step 2 – Right Click on the Selected Text and Click on Format Cells

  • Right click on the selected text.
  • A pop-up menu i.e. the context menu will appear.
  • Click on the Format Cells Option.

Step 3 – Go to the Alignment Tab

  • Go to the Alignment Tab in the Format Cell dialog box.

Step 4 – Uncheck the Wrap Text Check Box and Click on OK

  • Uncheck the Wrap Text check box in the Alignment Tab.
  • Click on OK in the Format Cells dialog box.
  • The selected text will be unwrapped.