column heading as letters instead of numbers


Posted by Susan Riley on February 09, 2000 2:10 PM

Apologies if this is a bonehead question. But recently, my computer crashed and when the program came back up, the column letters were changed to column numbers. This doesn't make sense to me. How can I designate cells in a worksheet if the columns and rows and the same designation?

Thank you in advance for any/all help.



Posted by Kieth Hoar on February 09, 2000 2:20 PM

Open any workbook.
Click Tools, then options, then select the General tab.

Unselect the R1C1 Reference Style.

HTH
Keith