change column headings letters

G

Guest

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

Nick Hodge

Green Goose

Tools>Options....>General, uncheck R1C1 reference style

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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

Guest

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
Click to expand...
 
G

Guest

THANK YOU!!!!

That was driving me nuts!

Nick Hodge said:
Green Goose

Tools>Options....>General, uncheck R1C1 reference style

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
Click to expand...
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

column headings display as numbers 2
column headings 1
Setting Column Headings 1
Excel column/row set up 1
The columns always were A, B, C, D,... They are now numbers. How. 1
Change Column Headings 1
Column Headings 1
why have column letters changed to numbers in excel 1

Top