M
Marco
My columsn are numbered. They are no longer alphabetized. I am using excel
2007 and I have no idea why this has happened. Please help.
2007 and I have no idea why this has happened. Please help.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
FSt1
hi
your reference notation has switched from A1 to R1C1. Why? no clue.
to change back.....
chick the office button then excel options.
on the left side click formulas
uncheck R1C1 reference style.
regards
FSt1
your reference notation has switched from A1 to R1C1. Why? no clue.
to change back.....
chick the office button then excel options.
on the left side click formulas
uncheck R1C1 reference style.
regards
FSt1
P
PCLIVE
I'm not sure about XL2007, but I'm sure it's similar. Go to
Tools|Options|General (Tab).
Uncheck 'R1C1 reference style'.
HTH,
Paul
Tools|Options|General (Tab).
Uncheck 'R1C1 reference style'.
HTH,
Paul
D
Don Guillett
Excel options>formulas>working with formulas>uncheck r1c1
D
David Biddulph
In Excel 2003 it's Tools/ Options/ General
Unset R1C1 reference style
According to the 2003 to 2007 translation guide
(http://office.microsoft.com/en-us/excel/HA101491511033.aspx), in Excel 2007
the equivalent of Tools/ Options is Office button/ Excel Options.
Unset R1C1 reference style
According to the 2003 to 2007 translation guide
(http://office.microsoft.com/en-us/excel/HA101491511033.aspx), in Excel 2007
the equivalent of Tools/ Options is Office button/ Excel Options.
F