Why does my Excel shows the rows and the columns as numbers?

[Coulum/Row Reference]

The row references are number and, usually, the column references are
letters; however, somehow my Excel file was changed and the rows and colums
are numbers. How did this happen and/or how do I change it back?

 

[Peo Sjoblom]

Tools>options>general remove checkmark from R1C1 reference style

--


Regards,


Peo Sjoblom

 

[Tom Hutchins]

Tools >> Options >> on the General tab, uncheck the R1C1 reference style box
Hope this helps,

Hutch

 

[Harald Staff]

Hi Peo

Most replies in newsgroups seem to -& most often correctly- assume that the
OP is not using Excel 2007? Is there any explanation to this?

Best wishes Harald

 

[Peo Sjoblom]

Hi Harald,

I just assumed

Plus of course unless this is the OP's first Excel experience most users
mention that they
use 2007 if that's the case.

--


Regards,


Peo Sjoblom

 

[David Biddulph]

Most experienced Excel users have not changed to 2007.
Newcomers to Excel are often satisfied with 2007, but those accustomed to
using 2003 prefer it over 2007. The main concerns are the replacement of
menus by the ribbon, and some degradation in charting functionality.
Natrurally the extended limits, such as on number of rows, number of
columns, and nesting depth, are an advantage in 2007.