Columns in Excel labeled numbers rather than letters?

G

Guest

All of a sudden the columns in my Excel documents are labeled with numbers
rather than letters. It's making it confusing to do vlookups, etc.

Any suggestions for how this happened and how to undo it?
 
D

Dave Peterson

Tools|Options|General Tab|Uncheck "R1C1 reference style"

This is determined by the first workbook you open in that excel session. So if
you happen to open a workbook that someone saved in R1C1 reference style as the
first workbook, you'll have to do it again.
 
G

Guest

Thank you so much! What a relief! :)

Dave Peterson said:
Tools|Options|General Tab|Uncheck "R1C1 reference style"

This is determined by the first workbook you open in that excel session. So if
you happen to open a workbook that someone saved in R1C1 reference style as the
first workbook, you'll have to do it again.
Click to expand...
 

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
Columns now numbers rather than letters how do i get letters back 2
Column headers numbers instead of letters 2
Why are my Columns labeled with Numbers rather than letters? 1
Columns are Numbers 5
Columns Labeled 1
Columns are numbers instead of letters 4
How to change column titles from numbers to letters. 3

Top