Why are my columns numbered instead of lettered?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use the command Tools | Options; open the General tab; unselect the top left
box "R1C1 reference style"
best wishes
 
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
 
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
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top