If Biff's answer isn't what you are lookinmg for, is it perhaps "Format /
Cells / Wrap text", or even when inside a cell, ALT+ENTER will force a line
break within a cell, eg Type "abc" then hit ALT+ENTER, then type "def" and
you will end up with

abc
def

in the same cell

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"cmoore" wrote:

I always see excel sheets with nice names on top of the columns but I can't
find out how to do it. I always seem to have narrow columns with longer
names that look goofy when do them now. For instance one column would be
Black or Color, so every column below that would only need to have either
black or color typed into it, but since I can't figure out how to make the
name say black on top-or in the middle-color on the bottom the cell is over
twice as wide as I need it to be.

TIA