fbpx

How to Wrap Text in Excel Automatically and Manually

Wrap Text is most known function of excel. There are times when there is difficulty to adjust long texts within an excel cell. When you’ve much text piled up and it should be present in the spreadsheets. Or if you have failed to fit your text in an Excel Cell. Excel Wrap Text option will help you fit a long text in an excel cell or adjust long texts within an excel cell.

What is Wrap text

Download Wrap Text in Excel Sample File

Downlaods

Well, what you can do about this is, learn how to make an excel cell expand to fit the text.

What is the Shortcut to Wrap text in Excel?

Shortcut to Wrap Text in Excel is: Alt + Enter

(Press and hold the Alt key and then press and release the Enter Key without releasing the Alt key on the Keyboard.)

  • Go to Home Tab, go to Alignment Group
  • Click on the Wrap Text Button
  • Press Ctrl + 1
  • Click on the selected cells
  • Click on the Format Cells dialog box
  • Go to Alignment Tab
  • Check/Tick on the Wrap Text Checkbox
  • Click OK.

When you want to fit long text in Excel using Wrap Text, Microsoft lets you do this by offering few other ways. The tutorial is all about the Microsoft Excel Wrap Text Feature and also about the quick tips on how to use Wrap Text in Excel wisely.

Download Wrap Text in Excel Sample File

Downlaods

Interested to learn ‘How to freeze Rows and Columns in Excel’? Click on the link and check now. CLICK

Let’s look at these questions:

  1. When do you use wrap text in Excel?
  2. How to wrap text in Excel automatically?
  3. How to insert a line break manually?
  4. Excel wrap text not working?

When do you use wrap text?

Sometimes, there is a large amount of Data in an Excel Cell and you don’t know how to fit the long text in an Excel Cell. The reason is, the data is too large.  During this situation, the two situations are for sure to strike.

  • When the columns towards the right side are empty, you’ll observe that the cell border of the Columns will be extended with long text strings.
  • When there is any data in the adjacent cell at the right. At the cell border, you’ll observe the text string is cut off.

In the image, you’ll get to see where to find Excel Wrap Text icon in Excel.

Also, you’ll find those two cases are displayed:

  • The longer text is extending to the right column
  • The longer text is getting shortened.

Where and Why to use Wrap text

Do you know how to use the Excel Wrap Text Feature? The Excel Wrap Text Feature will help you to display and learn how to fit the long text in Excel using Wrap Text in an individual cell. What happens is, there are times when some texts get lost in the next line. The main advantage is, the text here won’t overflow in the adjacent cell.  With “Wrapping Text” you’re able to Wrap the text in Multiple Lines rather than displaying it on one long line. This helps you in avoiding the “Truncated Column effect”.  As you can see, the text is overflowing from the Column and getting Truncated towards the right. Which is making the readability of the text a lot easier than before. Also, it makes text adjustments for its printing.

Add on: The main contribution of the Wrap text feature in Excel is that, it helps to retain the main width of the Column in the entire Worksheet. 

In the image, you’re able to see how a wrapped text looks like in Excel.

How to wrap text automatically?

If you wish to obtain the lengthy text string or see it on Multiple Lines or line of text in cell, you need to select the cell(s) that you wish to Format. Now, you need to turn on the Excel Text Wrap Feature on.

Steps to Wrap Text in Excel:

  1. Select the cells
  2. Go to the Home Tab
  3. Click on the Wrap Text Button

How to Wrap text method 1

Or you can:

  1. Select the cells
  2. Press Ctrl + 1, to open the Format Cells dialog box
  3. Check/Tick the Wrap Text Checkbox and then click OK

How to Wrap text method 2

Compared to the first method, this will be a tricky and complicated one. It might need few of your Extra clicks but with this is wrapping text would become easy.

Cell Formatting: Here will bargain you some time. If you wish to bring changes in the Cell Formatting at a time, wrap up text option will be one change.

Important Tip: When you observe that the Wrap Text Checkbox is Solid-filled. This indicates that setting the selected Cells has different Text Wrap.

Result: It doesn’t matter what method you’re using. The data in the selected cells wraps to fit the column width. This is why, on changing the column width, text wrapping will adjust automatically.

How to unwrap text in Excel?

Click on the Wrap Text Button (In the Home Tab> alignment group)

There are two ways to Unwrap Text in Excel:

Method 1: Clear the text checkbox on the Alignment tab

Method 2: Press Ctrl+1. This will open the Format Cells Dialog box

Steps for Method 1:

  1. Select the Cells
  2. Go to the Home Tab
  3. Go to Wrap Text and Unselect the Wrap Text Option

Steps for Method 2:

  1. Select the Cells
  2. Press Ctrl+1. This opens the Format Cells Dialog box
  3. In the Alignment group, Clear/untick/uncheck the Wrap text checkbox

Unwrap text in Excel

How to insert a line break manually?

When to insert a line break manually, these steps are to be followed:

  1. Click on any of the Cell and Press F2 and enter the cell edit mode
  2. Press Alt+Enter (Place the cursor where you want to break the line)

Conclusion:

When you insert a line break it turns on the Wrap Text Option automatically.  Whereas when you enter the line break manually, this will stick at the same place even when the Column is made wider.

When you turn off the Text Wrapping, the data will be displayed in one line in a cell. Also, If you wish to see the line breaks inserted, you’ll be able to find these in the Formula Bar.

In the image, you’ll be able to observe both the situations. A Line break is entered after the word ‘love”.

Break text manually

 

How to autofit Fixed row height in Excel?

In case, if all the wrapped texts are visible in a cell, the certainty is, the row might be set to a particular height. There are two methods by which you can fix this Problem:

Method 1: Set a specific height for the row, this can be done by clicking on the Row Height

Method 2: Autofit the height for the Row by selecting the Autofit Row Height Option

Method 1:

  1. Select the Problematic cells
  2. Go to the Home Tab
  3. In the cells group, Click on Format
  4. Select/Click on the Row-height Option
  5. In the Row Height Dialog Box, Enter the Row-height you want (In our case, we have taken 45.)

Method 2:

  1. Select the Problematic cells
  2. Go to the Home Tab
  3. In the cells group, Click on Format
  4. Select/Tick on the Auto-fit Row Height Option

Method 1 & Method 2 Explain in below Image

Adjust Row Height

How to Merge and center in Excel?

If you have merged Cells, wrap text won’t work.

To Wrap the Text of Merged cells, you’ll have to:

  1. Unmerge the cells by going to Home Tab> Alignment Group> Merge & Center dropdown> Click on the Unmerge Cells
  2. Select the Unmerged Cells
  3. Click on Wrap Text

Suppose, if your cell doesn’t show Wrap Text then you’ll need to adjust the Row Height.

Also, Steps to adjust the Row Height are explain above.

Excel’s Wrap Text feature isn’t flexible when working with the merged cells. So, you must decide which feature will work best and for the particular Worksheet. Using the merge Cells Option, you’ll be able to display the whole text string in the columns. You’ll need to make the Column Wider.

You’ll observe the cell here is wide enough for displaying the value.

Do not wrap a cell(s) that is already wide enough to display its contents. The reason is, if you try to, nothing will happen to the text. In case, if you resize the Column for the further entries, the column might become too narrow in size. It becomes difficult to adjust the longer entries in this. Toggle the Excel Wrap Text Button off and then on again, just in case, if you wish to fit a long text in Excel using wrap text.

Download Sample File

Downlaods

You can even learn about How to Remove Blank Row in Excel. Click on the link and check now. CLICK

Excel Ninja Course
Limited Period Offer.

30-Day Money-Back Guarantee

Includes:


11+ hours on-demand video
Full Lifetime Access
Success on mobile and TV
Certificate of Completion
Downloadable Case Studies
Lifetime Support

Related Tutorials

Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Split Cells in Excel using Text to Column
June 7, 2018
How to Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018
5 Powerful Tricks to Format cells in Excel
May 31, 2018
Insert a Picture into a Cell in Excel
May 25, 2018
What is ISFORMULA Function and FORMULATEXT Function
May 21, 2018
How to Use SUBSTITUTE Function
May 21, 2018
Excel Quartile Function in Excel
May 8, 2018
How to use the Excel PERCENTILE function
May 7, 2018
Insert or Type degree symbol in Excel with Autocorrect Feature
May 7, 2018
Insert Symbol Dialog Box to Insert or Type degree symbol in Excel
May 7, 2018
CHAR Formula to Insert or Type degree symbol in Excel
May 7, 2018