ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 changed the column Letters into numbers (https://www.excelbanter.com/excel-discussion-misc-queries/160294-excel-2007-changed-column-letters-into-numbers.html)

Bob WIFI HomeAutomation Guy

Excel 2007 changed the column Letters into numbers
 
lWithout my input, Excel 2007 has changed all my column heading letters into
numbers, and all cell references in equations are now done by cell vectors.
How do I change it back :-( I don't want to type R[1]C[1] to address cell A1.

Chip Pearson

Excel 2007 changed the column Letters into numbers
 
Click on the Office button (the big round button at the upper left of the
screen), choose Excel Options, then Formulas. There, uncheck the "R1C1
Reference Style" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Bob WIFI HomeAutomation Guy"
m wrote in message
...
lWithout my input, Excel 2007 has changed all my column heading letters
into
numbers, and all cell references in equations are now done by cell
vectors.
How do I change it back :-( I don't want to type R[1]C[1] to address cell
A1.




All times are GMT +1. The time now is 05:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com