Excel Spreadsheet

[Guest]

I have been given a spreadsheet to work on that has the column headings
across the top shown as numbers instead of the usual letters (ABCDEFG etc)
How do I get it to show the letters again please?

 

[Guest]

Tool=>Options=>General--> Uncheck R1C1 reference style (in Settings)

 

[Trevor Shuttleworth]

Tools | Options | General tab | deselect R1C1 reference style

Regards

Trevor

 

[Guest]

Trevor

Thank you very much for your fast response, it worked and I really do
appreciate your help.

Thanks again

 

[Guest]

Trevor

Why would you want to refernce the headings like that anyway? Would you know?

 

[Guest]

Thanks Toppers but why would you want to ref this way anyway?

 

[Trevor Shuttleworth]

I guess it's just personal choice and probably something to do with backward
compatibility with Lotus 123. Personally, I wouldn't choose it but I'm sure
are there are lots of people who do.

Regards

Trevor

 

[Guest]

Hi,

Do the following:

1. On the Tools menu, click Options.
2. In the Options dialog box, click the General Tab
3. Click to slect the R1C1 Refernce Style check box
4. Click Ok to return to active worksheet. Now the column heading have
changed to ABCDEFG and so on.

Challa Prabhu

 

[SwatMan]

How does this work in Office 2007 which has no tools menu?

 

[T. Valko]

In Excel 2007:

Click the Office button
Excel Options>Formulas>Working with formulas>uncheck R1C1 reference style>OK