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

You can either put the title in 2 cells:

A1 = Black
A2 = Color

Or

In A1: type Black, hold down the ALT key then hit ENTER, type Color. A1 will
look like this:

Black
Color

Biff

"cmoore" wrote in message
...
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

P.S.

You can experiment with font size, row height, column width until you get it
exactly how you want it.

Biff

"Biff" wrote in message
...
You can either put the title in 2 cells:

A1 = Black
A2 = Color

Or

In A1: type Black, hold down the ALT key then hit ENTER, type Color. A1
will look like this:

Black
Color

Biff

"cmoore" wrote in message
...
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

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