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

  • Thread starter Thread starter B Lutz
  • Start date Start date
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?
 
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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Change Excel column headers from numbers to letters 1
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
Excel sheet with numbers as column & row headers - How? 3
Colunmn headers 4
In MS Excel, how do I change the column ref headers from numbers . 2

Back
Top