Columns in Excel labeled numbers rather than letters?

Z

zrossing

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.
 
Z

zrossing

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...
 
Top