change column headings letters
 

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

Green Goose

ToolsOptions....General, uncheck R1C1 reference style

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Green Goose 89" <Green Goose wrote in message
...
The column headeing in Excel have somwhow changed to numbers (the rows are
still numbers). How do i change them back to letters?

ToolsOptionsGeneral.

Uncheck "R1C1 reference style".


Gord Dibben Excel MVP

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

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

THANK YOU!!!

That was driving me nuts!

"Gord Dibben" wrote:

ToolsOptionsGeneral.

Uncheck "R1C1 reference style".


Gord Dibben Excel MVP

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

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

THANK YOU!!!!

That was driving me nuts!

"Nick Hodge" wrote:

Green Goose

ToolsOptions....General, uncheck R1C1 reference style

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Green Goose 89" <Green Goose wrote in message
...
The column headeing in Excel have somwhow changed to numbers (the rows are
still numbers). How do i change them back to letters?

change column headings letters
 

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?



--
sorbet
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1393429.html