Manually Wrapping Text in a Cell

In this article, we are going to learn how to manually wrap the text and how to cancel manual text wrapping in Microsoft Excel.

What is Text wrapping?

To show the text from multiple lines in a cell, we format the cell by using the option Text wrap or we can enter a manual line break.

How we can do manually text wrap

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

Follow below steps:-

Select the cell A1, and press key F2.

Press keys ALT + Enter and then again Press Enter key.

In above shown image, you can see that text adjusts in a cell.

How to cancel manual text wrapping?

To cancel manual text wrapping, follow below steps:-

Select the cell A1.

Go to home tab > Alignment group > Click on wrap text.

Wrap text command will get cancelled.

Take away:-

Manually Text wrapping in a cell
Way to cancel the command.

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

Vinayak
February 5, 2014 at 1:23 pm

Is there any other way to do the same process for 100 line items or more?

Reply ↓
- Rishi Saw
  February 6, 2014 at 7:29 am
  
  Hi Vinayak,
  
  We can do the same process for 100 lines items or more, via VBA
  Please post your query on excelforum.com.
  
  many thanks
  Rishi
  
  Reply ↓
Ron
August 23, 2013 at 8:27 am

Excel can be used to build tables and work on them like word with txt wrapping etc., but is there a way where we can insert a blank line in the same column where a long sentence is typed. This causes more readability and even reduces the usage of word, as excel we have excellent formulas to work with, and we can continuously work on it.

Reply ↓