Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
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.
Wrap Text in Excel (Table of Contents)
What is Wrap Text in Excel?
When we have data in a cell which has more values or characters than the cell size then the data in the cell not visible normally as it is more in size than the rest of the cells, excel has an inbuilt function to view all of the data available in the cell which is wrap text and it allows a user to see the data in multiple lines in the same cell, it is available in the home tab of the alignment section.
- Primarily Microsoft excel is designed to handle large numbers and calculations but sometimes we get stuck in a situation where we want to enter a large sentence in a single cell and that sentence does not get properly displayed in that cell.
- This happens because the width of the cell is less than the width of the cell, in which the text is entered and hence we did not see a complete sentence that is in that cell. Since the width of the cell is less than the width of the sentence, we see only that part of the sentence that can be fit in the width of the cell. We can correct this situation in two ways.
- Either we can increase the width of the cell or we can choose to wrap the text. Choosing to increase the width of the cell is not a good option when we have a large count of columns that are to be displayed in the workbook. If we increase the width of the column then this decreases the numbers of columns that can be displayed on the screen without scrolling the sheet.
- So, the best way will be to stick to the inbuilt option of “Wrap text”. Wrap text in excel enables a user to show a complete sentence that is in the cell without increasing the width of the column.
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 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
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.
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
Explanation of Wrap Text in Excel
In excel often Shrink text is considered as a wrap text but this is not correct as both of the functions of Excel are for a different use. If we are using the shrink text function then this means that we want excel to decrease the font size as needed to display the complete text in the single cell. However, in case of using Wrap Text in excel, the complete sentence is displayed without decreasing the font size.
- The functioning of Wrap text can be explained as increasing the row height instead of increasing the column width to display a sentence whose width is more than the width of that column to which the cell belongs.
- Wrap text increase the row height and add line breaks to the sentence and then shifts that part of the sentence to the next line within the cells that falls beyond the cell width and hence by doing this it enables the complete sentence to be displayed in that single cell.
- Using excel wrap text is advised as that part of the text that does not fall within the width of the cell will cross the border of that cell and will be displayed over the next cell, if the next cell is empty. This creates serious formatting issues.
- This is often said that why should we use the Excel Wrap Text function when we can add a line break to the sentence?
- The answer to this is quite simple, as adding a line break is manual work and require user time. However, Wrap text automatically inserts a line breaks to that part of the sentence that cannot be displayed in the single cell. This feature is so automatic that it will adjust the line break if any changes are made to the width of the cell.
Things to Remember Wrap Text in Excel
- 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 line break if we need the format of 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 “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 –