Text Not Wrapping

G

Guest

hi,
I am having trouble understand what "hit enter and stay in
the same cell" has to do with autofit and wrap text.
if you want to "hit enter and stay in the same cell" then
goto Tools>options>edit>Move selection after enter.
 
S

swatsp0p

I agree with anon. I believe baby wants to have multiple lines of text in
the same cell, using a carriage return to move to the next line in the same
cell. Excel cannot do this in a cell. You have to enter all the data "on
one line" and then with word wrap on, size the cell to make it fit on two (or
more) lines. Excel is not designed to be a word processor within a cell.

Again I say: if you have multilple listings, you need multiple columns so
you can control the data independently.

HTH
 
B

BabyBlueAXiD

I will give an exapmle of what I wwant it to look like

radio 555-5555
cell 555-5555
pager 555-5555
....all in the same cell
the cell does not adjust when I hit enter it either puts me in the cell
below or overrides the information in that cell
 
S

swatsp0p

Try this: in one cell enter: "radio 555 555-5555 cell 555 123-4567 pager 555
234-5678" (without the quotes) and press ENTER. Right Click in this cell and
select "Format Cells..." and click the Alignment tab, under Text Control,
click the Word Wrap check box and click OK. Assuming you are using Arial 10
pt. font, size this column to 16.86 and size this row to 39.00. Now it
should be on three lines within the one cell.

good luck!
 
V

vanjohnson

Another way would be to hit 'Alt + Enter' at the end of the line when you
want it to stay in the same cell.
 
S

swatsp0p

Alt+Enter commits the data entered and leaves the current cell selected.
This will not, however, meet baby's need of entering multiple lines of text
in the same cell. Excel does not support treating a cell as a "text box".

This is a good tip, though, for those times one wants to not have the active
cell move upon committing an entry.
 
Top