Why are my columns numbered instead of lettered?
 

I bought a new computer and for some reason the Excel spreadsheet does't sho
Letters for the columns, as usual, but instead it shows numbers. So both my
columns and my rows are numbered, and when I enter a formula I really don´t
undrstand how it works. For example, i get this in the cell: =FC(-1)*F2C3
when I am used to working with th number and letter reference: =c1+c2
I tried to look for ways to change this, but did't succeed. Please help.

Why are my columns numbered instead of lettered?
 

Use the command Tools | Options; open the General tab; unselect the top left
box "R1C1 reference style"
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"valy" wrote in message
...
I bought a new computer and for some reason the Excel spreadsheet does't
sho
Letters for the columns, as usual, but instead it shows numbers. So both
my
columns and my rows are numbered, and when I enter a formula I really
don´t
undrstand how it works. For example, i get this in the cell: =FC(-1)*F2C3
when I am used to working with th number and letter reference: =c1+c2
I tried to look for ways to change this, but did't succeed. Please help.

Why are my columns numbered instead of lettered?
 

Tools Options General and clear the R1C1 reference checkbox
--
Gary's Student
gsnu200704


"valy" wrote:

I bought a new computer and for some reason the Excel spreadsheet does't sho
Letters for the columns, as usual, but instead it shows numbers. So both my
columns and my rows are numbered, and when I enter a formula I really don´t
undrstand how it works. For example, i get this in the cell: =FC(-1)*F2C3
when I am used to working with th number and letter reference: =c1+c2
I tried to look for ways to change this, but did't succeed. Please help.

Why are my columns numbered instead of lettered?
 

ToolsOptionsGeneral

Uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP

On Wed, 7 Feb 2007 09:53:02 -0800, valy wrote:

I bought a new computer and for some reason the Excel spreadsheet does't sho
Letters for the columns, as usual, but instead it shows numbers. So both my
columns and my rows are numbered, and when I enter a formula I really don´t
undrstand how it works. For example, i get this in the cell: =FC(-1)*F2C3
when I am used to working with th number and letter reference: =c1+c2
I tried to look for ways to change this, but did't succeed. Please help.

Why are my columns numbered instead of lettered?
 

If using Excel 2007: Select Office Button in top left corner. Choose Excel Options button at bottom of new window. Select Formulas. Go to Working with formulas and unselect the box next to R1C1 reference style.



Gord Dibben wrote:

Why are my columns numbered instead of lettered?
07-Feb-07

ToolsOptionsGeneral

Uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP

On Wed, 7 Feb 2007 09:53:02 -0800, valy wrote:

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorials...l-view-vi.aspx