| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell 2000--My column headings have changed from letters to numb | Excel Discussion (Misc queries) | |||
| Row headings have changed from letters to numbers. How do I undo? | Excel Discussion (Misc queries) | |||
| why have column letters changed to numbers in excel | Excel Discussion (Misc queries) | |||
| the letters across the top in excel have changed to numbers why | New Users to Excel | |||
| My excell column letters have changed to numbers. I don't want th. | Excel Worksheet Functions | |||
Linear Mode
