Excel 2007 changed the column Letters into numbers

  • Thread starter Bob WIFI HomeAutomation Guy
  • Start date
B

Bob WIFI HomeAutomation Guy

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.
 
C

Chip Pearson

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
reference format and column name 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Missing Row Column Numbers Not Column Letters 1
Change all text on Spread sheet 3
Paragraph numbering in Word 1

Top