Column Labels switched from letters to numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Melanie - 09 Oct 2003 21:32 GMT

I opened a spreadsheet from another user. It
automatically converted my column labels (A,B,C...) to
numbers. When I click on a cell the reference is now R1C1
etc. I would like to change them back to letters, but can
not find where to do this. I have tried completely
shutting down excel and then opening again but these
setting seem to remain. How can I fex this?

Reply to this Message

Dave Peterson - 10 Oct 2003 00:44 GMT

Tools|Options|General Tab
Uncheck the R1C1 reference style checkbox.

And save your workbook.

Excel picks this setting up from the first workbook you open in that session.
(If you have others saved as R1C1 style and open them first, you'll have to do
it again. So it's a good one to remember.)

> I opened a spreadsheet from another user. It
> automatically converted my column labels (A,B,C...) to
[quoted text clipped - 3 lines]
> shutting down excel and then opening again but these
> setting seem to remain. How can I fex this?

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message