Cell formatting problem using MS EXCEL

Asked By Frankie Hilton 0 points N/A Posted on - 03/26/2012

How can I format a column in such a way that all contents will be seen in a short single column unlike what is shown in the picture.

I just want the content be seen on the red column that I draw.

• Status: Open
• Question Views: 931
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by marlaaustria

Go To Solution

Best Answer

Best Answer

Answered By marlaaustria 0 points N/A #119233

Cell formatting problem using MS EXCEL

 Formatting the cells in your excel worksheet is an easy task, just follow the following instructions I will give. By the way, I’ve copied your sentence to my own excel worksheet to give you a visual example of what you can do.

First of all, you need to adjust the column with your desired size.

Secondly, click on the sentence that needs formatting.

Thirdly, right-click the sentence or cells that you want to format.

Fourthly, select the format cells button and click the alignment tab on the upper portion.

Lastly, check the ‘Wrap Text’ box and press ok.

I hope this solution will help you.

About marlaaustria

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 03/27/2012
• Question Category: MS Excel

Answered By Sherin Viluel 0 points N/A #119235

Cell formatting problem using MS EXCEL

The column can be adjusted according to the way you want to see it. You can follow the either of following two methods to adjust the column.

Method 1

First type the sentence or paragraph in a single cell that you want. (E.g.: we assume the cell is B2)

Point to note: please do not drag any cell before and after type the sentence or paragraph

Then select the cell that you typed and go to the Home tab, alignment section and click on the “Wrap text” option.

Method 2

First type the sentence or paragraph in a single cell that you want. Do not drag any cell same as fist method.

Then right click on the cell, click format cell, select alignment tab tick on the “wrap text” check box.

Then you will be able to see all the contents in a single column as you wish.

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/16/2012
• Question Category: MS Excel