General Question

FrankHebusSmith's avatar

In excel how do I keep words from overlapping? ...

Asked by FrankHebusSmith (4319points) December 14th, 2009

I’m making an excel sheet for work, and as I type words into one cell, if they extend longer than that cell they overlap the next cell (assuming that cell is empty, which in this case it is). I’ve made the cells larger (height and width) specifically to make them able to contain all of the words in them, but I don’t remember how to make them drop down to a new line when they run out of space in the cell (ala like word does when you fill a line on a page).

Does anyone remember how to do this? It’s Excel 2003 if it makes any difference. Thanks

Observing members: 0 Composing members: 0

3 Answers

EmpressPixie's avatar

Right click.
Format cell.
Alignment tab.
Check the wrap text box.

FrankHebusSmith's avatar

I KNEW it was something simple like htat, thank you much

prasad's avatar

Yeah, Wrap text as @EmpressPixie told.

If you ever want to enter into the new line into the cell (like you do hitting enter in Word), press ”ctrl + Enter”.

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther