Basic question on excel: Cell display

Asked By calistamadisonn 0 points N/A Posted on - 11/21/2012

Basic question on excel: I am working on my grading sheet on excel and I want to put a long sentence in a single cell without occupying a lengthy row.

I want it to fit in a cell with just a small width and length.

How will I do it?

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

• Answer Accepted: Yes
• Question Category: Software Others

Best Answer by Wastler Markus

Go To Solution

Answered By becky cruz 0 points N/A #141702

Basic question on excel: Cell display

Try the steps below:

a. Right click on the cell > Format Cells.

b. Go to the Alignment tab.

c. Either check Wrap text or Shrink to fit, whichever fits your purpose.

d. Click OK.

About becky cruz

Questions
3

Answers
12

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/21/2012
• Question Category: Software Others

Best Answer

Best Answer

Answered By Wastler Markus 0 points N/A #141703

Basic question on excel: Cell display

Hi Calistamadisonn,

You can maximize a cell in MS Excel with one to two long sentences without making it look unorganized.

When you have two sentences and you want the 2nd sentence on the 2nd line; yet every time you press Enter, the selection goes to the next cell.

There is a solution for this. Instead of pressing only the enter button after the 1st sentence, you need to click on alt+Enter so that the 2nd sentence will appear on the 2nd line but on one cell.

Hope this helps.

About Wastler Markus

Questions
3

Answers
28

Best Answers
22

• Vote Up 0 Vote Down

• Posted on - 11/22/2012
• Question Category: Software Others