change column headings letters

G

Green Goose 89

The column headeing in Excel have somwhow changed to numbers (the rows are
still numbers). How do i change them back to letters?
 
G

Gord Dibben

Tools>Options>General.

Uncheck "R1C1 reference style".


Gord Dibben Excel MVP

On Tue, 1 Feb 2005 13:43:01 -0800, "Green Goose 89" <Green Goose
 
G

Green Goose 89

THANK YOU!!!

That was driving me nuts!

Gord Dibben said:
Tools>Options>General.

Uncheck "R1C1 reference style".


Gord Dibben Excel MVP

On Tue, 1 Feb 2005 13:43:01 -0800, "Green Goose 89" <Green Goose
 
S

sorbet

In my case I came across a column heading in Excel having somewhow
having Beta(Greek?)letters instead of the usual ABC. How do I change
them back to regular letters?
 
Top