Skip to content
Related Articles

Related Articles

Save Article
Improve Article
Save Article
Like Article

How to Wrap Text in Excel?

  • Last Updated : 04 Aug, 2021

Microsoft Excel’s Wrap text allows the content of the cell to appear on multiple lines within a cell; rather than a long line. This feature makes it easy to view the cell content at a glance.

Attention reader! Don’t stop learning now. If you are an Excel beginner (or an intermediate) and want to learn Excel, Geeksforgeeks brings the perfect course for you to start, Diving Into Excel

There are five ways we can Wrap Text in Excel:

Wrap Text From Ribbon

Follow the below steps to wrap text using Ribbon:



Step 1: Select the cell that you want to change.

Step 2: On the Home tab, in the Alignment group, click Wrap Text.

Removing Wrap Text via Ribbon

Follow the below steps to remove text wrap from the ribbon:

Step 1: Select the cell that you want to unwrap.

Step 2: On the Home tab, in the Alignment group, click Wrap Text.



 

Wrap Text Keyboard Shortcut

Follow the below steps to wrap text using the keyboard shortcut:

Step 1: Select the cell that you want to change.

Step 2: Press Alt + H +W on your keyboard.

Removing Wrap Text via Keyboard Shortcut

Follow the below steps to remove wrap text using the keyboard shortcut:

Step 1: Select the cell that you want to unwrap.



Step 2: Press Alt + H +W on your keyboard.

Wrap Text In The Format Cells Dialog Box

Follow the below steps to wrap text using Format Cells dialog box:

Step 1: Select the cell that you want to change.

Step 2: Right-click; click on Format cell on the Dialog Box.

Step 3: Select Alignment, in the Format Cells Dialog Box.

Step 4: Check Wrap Text in the Text Control option and click OK.

Removing Wrap Text via Format Cells Dialog Box

Follow the below steps to remove wrap text using the format cells dialog box:

Step 1: Select the cell that you want to change.

Step 2: Right-click; click on Format cell on the Dialog Box.

Step 3: Select Alignment, in the Format Cells Dialog Box.

Step 4: Uncheck Wrap Text in the Text Control option; click OK.



Manually Add Line Breaks To Wrap Your Text

Follow the below steps to manually add line breaks to wrap you text:

Step 1: Select the cell that you want to change.

Step 2: Place the cursor at the point in the text you want to add a line break.

Step 3: Press Alt + Enter. This will move the text down one line.

 

My Personal Notes arrow_drop_up