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

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?

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

Toolsoptionsgeneral remove checkmark from R1C1 reference style

--


Regards,


Peo Sjoblom

"Coulum/Row Reference" <Coulum/Row
wrote in message ...
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?

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

Tools Options on the General tab, uncheck the R1C1 reference style box
click OK

Hope this helps,

Hutch

"Coulum/Row Reference" wrote:

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?

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

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" skrev i melding
...
Toolsoptionsgeneral remove checkmark from R1C1 reference style

--


Regards,


Peo Sjoblom

"Coulum/Row Reference" <Coulum/Row
wrote in message
...
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?

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

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

"Harald Staff" wrote in message
...
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" skrev i melding
...
Toolsoptionsgeneral remove checkmark from R1C1 reference style

--


Regards,


Peo Sjoblom

"Coulum/Row Reference" <Coulum/Row
wrote in message
...
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?

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

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.
--
David Biddulph

"Harald Staff" wrote in message
...
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?

"Peo Sjoblom" skrev i melding
...
Toolsoptionsgeneral remove checkmark from R1C1 reference style

"Coulum/Row Reference" <Coulum/Row
wrote in message
...
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?