naming columns

[cmoore]

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

 

[Biff]

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

 

[Biff]

P.S.

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

Biff

 

[Ken Wright]

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