Basic question on excel: Cell display

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Wastler Markus
Answered By 0 points N/A #141702

Basic question on excel: Cell display

qa-featured

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.

Best Answer
Best Answer
Answered By 0 points N/A #141703

Basic question on excel: Cell display

qa-featured

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.

Login/Register to Answer

Related Questions