Excel 2007 changed the column Letters into numbers

G

Guest

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

column display, letters or numbers 1
Change Excel column headers from numbers to letters 1
why have my column headings changed to numbers 1
reference format and column name 1
Why did my Excel column headers change from letters to numbers? 4
how do i change the column headings from numbers to letters 2
Excel 2007... fix column headings from numbers back to letters 4
column headers changed from letters to numbers, how do I change ba 1

Top