Basic Question of Excel

[Neil Greenough]

Hey all,

This might sound like a basic question but i'm a novice when it comes to
Excel. All I want to do is unmerge cells so to speak. I am trying to make a
timetable, however when I write in one of the cells, the text continues on
and overlaps then next cell, instead of moving down in the same cell. I have
made the cells bigger so that you can fit 4 lines of text in them on top of
eachother. Anyone tell me how I would go about doing this, so that text
automatically stayed in cell, but went underneath (if you're with me!)

Thanks

 

[Stevo]

Hey all,

This might sound like a basic question but i'm a novice when it comes
to Excel. All I want to do is unmerge cells so to speak. I am trying
to make a timetable, however when I write in one of the cells, the
text continues on and overlaps then next cell, instead of moving down
in the same cell. I have made the cells bigger so that you can fit 4
lines of text in them on top of eachother. Anyone tell me how I would
go about doing this, so that text automatically stayed in cell, but
went underneath (if you're with me!)

Thanks

Point to the cell you have the text in, right click, select Format Cells..

On the Alignment page, check the 'Wrap Text' option..

 

[Brian H¹©]

Neil Greenough said:

Hey all,

This might sound like a basic question but i'm a novice when it comes to
Excel. All I want to do is unmerge cells so to speak. I am trying to make a
timetable, however when I write in one of the cells, the text continues on
and overlaps then next cell, instead of moving down in the same cell. I have
made the cells bigger so that you can fit 4 lines of text in them on top of
eachother. Anyone tell me how I would go about doing this, so that text
automatically stayed in cell, but went underneath (if you're with me!)

Thanks

Format | Cells | Justify

 

[oops]

Go to Format , cells , under alignment tab check Wrap text .

 

[Don Schmidt]

In Lotus 1-2-3 its in Range properties and called "wrapping".

 

[hugh jass]

The question was about Excel.
Hope this helps, hj
______________________
please remove the obvious from my email...
: In Lotus 1-2-3 its in Range properties and called "wrapping".
:
:
: --
: Don
: Vancouver, USA, a great city in one of the 45+ countries in America!
:
:
: : > Hey all,
: >
: > This might sound like a basic question but i'm a novice when it comes to
: > Excel. All I want to do is unmerge cells so to speak. I am trying to
make
: a
: > timetable, however when I write in one of the cells, the text continues
on
: > and overlaps then next cell, instead of moving down in the same cell. I
: have
: > made the cells bigger so that you can fit 4 lines of text in them on top
: of
: > eachother. Anyone tell me how I would go about doing this, so that text
: > automatically stayed in cell, but went underneath (if you're with me!)
: >
: > Thanks
: >
: >
:
:

 

[Helen]

Just let it overlap until you get all your columns done.
Then go to the Format tab, columns and click Auto Format.
This will size the column width to the length of the longest line
in that column.

Helen

 

[Robbie]

Just let it overlap until you get all your columns done.
Then go to the Format tab, columns and click Auto Format.
This will size the column width to the length of the longest line
in that column.

Helen

Or if you have changed the height of the cell, which by the sounds of it you
have... Right click on the cell, click on format cells, select the alignment
tab at the topof the window, and tick the wrap text button (in the middle of
the window on the left hand side)