Excel Column labels show as numbers

M

mrudnet

I am working in Excel 2007 and suddenly the columns are showing as numbers
and not the usual letters (A, B, C...). How do I change this back? Thanks.
 
J

JBeaucaire

Click the Office Button
Click the Excel Options
Go to Formulas tab
Go to Working with Formulas section
UNCHECK the R1C1 reference style
 

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
column labels 2
How to change column labels back to letters? 1
Excel sheet with numbers as column & row headers - How? 3
Cell References Format 2
column headers changed from letters to numbers, how do I change ba 1
Columns are numbers instead of letters 4
Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f 3

Top