Excel: change Column labels from 'A' to text?

D

Dave F

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
 
G

Gord Dibben

No you can't change the Letters to Names.

Use row 1 and enter your titles/names.

Tools>Options>View. Uncheck Row and Column Headers

Select A2 and Window>Freeze Panes.

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


Gord Dibben MS Excel MVP


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

Gord Dibben MS Excel MVP
 
Top