Why are my columns numbered instead of lettered?

[valy]

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.

 

[Bernard Liengme]

Use the command Tools | Options; open the General tab; unselect the top left
box "R1C1 reference style"
best wishes

 

[Gary''s Student]

Tools > Options > General and clear the R1C1 reference checkbox

 

[Gord Dibben]

Tools>Options>General

Uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP

 

[Jamie Fuller]

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:

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

Tools>Options>Genera

Uncheck "R1C1 reference style

Gord Dibben MS Excel MV


EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx

 

[Peter Girling]

Same Problem. Numbered on the desktop, letters on the laptop!

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.

On Wednesday, February 07, 2007 12:58 PM Bernard Liengme wrote:
Use the command Tools | Options; open the General tab; unselect the top left
box "R1C1 reference style"
best wishes

Submitted via EggHeadCafe - Software Developer Portal of Choice
Book Review: Excel 2010 - The Missing Manual [OReilly]
http://www.eggheadcafe.com/tutorial...w-excel-2010--the-missing-manual-oreilly.aspx

 

[Victor Delta]

Same Problem. Numbered on the desktop, letters on the laptop!

The answer was already given: