I want to label the columns as text instead of "A", "B" etc.

You can't change the column headings to text.

You can, however, make column headings of your own choosing in Row 1 and
then go to Tools--Options--View and deselect "show column headings" so row 1
would become your de facto column heading.

You would probably then want to freeze row 1 so that if you scrolled down it
wouldn't disappear. To do that, select row 2 and go to Window--Freeze panes.

Dave
--
Brevity is the soul of wit.


"PA_Dutch" wrote:

I want to label the columns as text instead of "A", "B" etc.

No you can't change the Letters to Names.

Use row 1 and enter your titles/names.

ToolsOptionsView. Uncheck Row and Column Headers

Select A2 and WindowFreeze Panes.

You could color row 1 gray to look like the column headers if you desire.


Gord Dibben MS Excel MVP


On Wed, 4 Oct 2006 10:09:02 -0700, PA_Dutch
wrote:

I want to label the columns as text instead of "A", "B" etc.

Gord Dibben MS Excel MVP