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
Columns now numbers rather than letters how do i get letters back 2
How to count the numbers in a Word document? 0
Embedded Excel into Word with Tables 0
Problem with SET & REF function 0
Cumulative formula for word table 0
Why did my Excel column headers change from letters to numbers? 4
why are my column headers numbers instead of letters? 2

Top