MS Excel Wrap Text Vertically

How many times when we wanted to do a report in MS Excel, we will have to use the Merge tool to merge a few columns together so that it’ll look presentable.

Microsoft Excel Logo

What about writing a few text on multiple lines and we instead enter the new line of words on a separate row?

It could be easier with this tutorial on how to Wrap your Sentences into One Column.

Sample Excel Wrapped Sheet

Refer the above picture, if you would like to wrap the text into one column, here is what you should do.

  1. Right click on the specific cell and click Format Cells.
  2. Go to Alignment tab. Choose Vertical Option and set it to Top.
  3. Tick the Wrap Text and click OK.

If you would like to view the instructions in graphical manner look at the graphical steps below.

Select Format Cells in Excel

Format Cells Option

Finally the result you are looking for is displayed.

Text Wrapped Excel Result

Need assistance, comment here and I’ll get back to you.

2 Comments

  1. danielctw January 27, 2011
  2. Bernard January 28, 2011

Leave a Reply