What is Wrap Text in Excel?
Wrap text in Excel belongs to the “Formatting” class of excel function that does not make any changes to the value of the cell but just change the way a sentence is displayed in the cell. This means that a sentence that is formatted as warp text is always the same as that sentence that is not formatted as a wrap text.
How to Wrap Text in Excel Automatically and Manually?
This is the most simple and quickest method of using the function of Wrap text.
Method #1 – By using the Wrap Text Option from the Ribbon
Select the cell that needs the Wrap Text and then go to the Home Tab and then from there choose the option of wrap Text. We will get the text displayed as below after Wrap Text.
Method #2 – Using the Formatting Cell Option to use Wrap Text.
Sometimes for those people who do not use the mouse often, they can use this Keyboard excel shortcut to wrap text.
- Step 1 – Select the cell that needs Wrap text and then press the shortcut key CTRL+1
- Step 2 – After the keyboard shortcut is pressed then the below window, from where we can choose the function of Wrap text and then click on OK.
Method #3 – Wrap Text Using the Keyboard Shortcut
Wrap text can also be directly applied by the below keyboard shortcut.
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
First, we need to Press Alt key then we need to release the Alt key and press H key
We will be applied to the first selected cell. After H key is pressed and released then we need to press W key and Wrap text.
Method #4 – How to Insert a Line Break Manually?
We can make some changes to the excel Wrap text function. We can as per we will insert a line break as per our need.
To insert a line break we just need to take the cursor to that part of the cell where we need to insert a line break.
Now we need to press the below keys at one time.
ALT + Enter key
Refer to the below-given Screenshot
Things to Remember
- Wrap text in excel will not work on Cells that are merged.
- Wrap text function will not work if the width of the cell is already more than the width of the sentence that is entered into that cell. In this case, we need to use a line break if we need the format of the wrap text.
- This feature might not work if “Height of Row” is fixed manually. In this case, we need to change the Row height to the “Automatic row height” function.
This has been a guide to Wrap Text in Excel. Here we discuss how to wrap text in excel using shortcut keys for wrapping the text along with practical examples and downloadable excel templates. You may also look at these useful functions in excel –