Automatically &Manually Wrapping Text in a Cell

In this article we will learn how we can automatically and manually wrap the text in a cell in Microsoft Excel.

Wrap text is used to show multiple lines in a cell instead of usage of multiple cells in Microsoft Excel 2010/2013. It is a part of format cells, just to select the option of “Wrap Text”, text wraps manually.

To understand automatically wrapping text in a cell in Microsoft Excel 2010/2013. Let’s take an example and understand:-
 

Wrap Text by using the shortcut command

I have text in cell A1, and it is using multiple cells. To convert the text into “Wrap Text” follow below mentioned steps:
 
img1
 
Step 1: Select the cell A1, right click on the cell, popup will appear, select “Format Cells” or you can do one more thing select the cell A1 and press the key “CTRL + 1”.

Step 2: The dialog box of “Format Cells” will appear. In the “Alignment” tab tick on “Wrap Text” and click on ok.
 
img2
 
Wrap Text by using Menu tab

To convert the text into “Automatically Wrap Text” follow below mentioned steps:

Step 1: Enter text into a cell A1 in the sheet.

Step 1: Select the cell A1, go to the main menu tab and select “Home” tab.

Step 2: In the group of “Alignment” click on the “Wrap Text”.
 
img3
 
To understand the manually wrapping text in a cell in Microsoft Excel 2010/2013. Let’s take an example and understand:-

 

Wrap Text Manually

I have text in cell A1, and the text is using multiple cells. I needs to use here “Wrap Text” so that cell will adjust the text manually.
 
img4
 

  • Select the cell A1, in the formula bar place the cursor after the word.
  • Press keys “ALT” + “Enter”

 
This is how you can wrap the text by using the tool Format Cell and through Command Button of Wrap text in Home Tab in Microsoft Excel 2010 and 2013.
 

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube