column headers changed from letters to numbers, how do I change ba

B

B Lutz

I'm using Excel 2007 and the column reference headers have change to numbers.
Both rows and columns are numbers. I don't know how this happen. How do I
change it back so that column references are letters?
 
F

FSt1

hi
click the office button then options.
At the left side of the dialog box, click Formulas
under working with formulas, uncheck R1C1 reference style.
ok

Regards
FSt1
 

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

Excel sheet with numbers as column & row headers - How? 3
Why did my Excel column headers change from letters to numbers? 4
Columns now numbers rather than letters how do i get letters back 2
Column header format 5
Showing Letters For Column Headers Rather Thann Numbers ? 1
Change Excel column headers from numbers to letters 1
In MS Excel, how do I change the column ref headers from numbers . 2
For Excel 2007 how do yu change column headers from numbers to let 1

Top