alpha column changed to numerical column
 

I don't know what happened. I had a spreadsheet with columns A,B,C..... and
all of a sudden it's showing up with columns 1,2,3,.....

It still has rows 1,2,3,....

Does anyone know how I can get the columns A,B,C.....back?

MSOffice XP is being used on a WinXP system
--
Thanks,
Diane

alpha column changed to numerical column
 

Hi Diane

ToolsOptionsGeneraluntick the R1C1 box

Regards

Roger Govier


DianeMcP wrote:
I don't know what happened. I had a spreadsheet with columns A,B,C..... and
all of a sudden it's showing up with columns 1,2,3,.....

It still has rows 1,2,3,....

Does anyone know how I can get the columns A,B,C.....back?

MSOffice XP is being used on a WinXP system

alpha column changed to numerical column
 

Never mind.... I found the setting under Tools, Options, General which
referenced the "R1C1 reference style" - which somehow got checked.....
unchecked it.....
--
Thanks,
Diane


"DianeMcP" wrote:

I don't know what happened. I had a spreadsheet with columns A,B,C..... and
all of a sudden it's showing up with columns 1,2,3,.....

It still has rows 1,2,3,....

Does anyone know how I can get the columns A,B,C.....back?

MSOffice XP is being used on a WinXP system
--
Thanks,
Diane

alpha column changed to numerical column
 

DianeMcP

Tools Options General tab Uncheck
'R1C1 reference style.

George Gee



DianeMcP wrote:
I don't know what happened. I had a spreadsheet with columns
A,B,C..... and all of a sudden it's showing up with columns
1,2,3,.....

It still has rows 1,2,3,....

Does anyone know how I can get the columns A,B,C.....back?

MSOffice XP is being used on a WinXP system