Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns in Excel labeled numbers rather than letters?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns in Excel labeled numbers rather than letters?
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. zrossing wrote: 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? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns in Excel labeled numbers rather than letters?
Thank you so much! What a relief! :)
"Dave Peterson" wrote: 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. zrossing wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
change column designators from numbers to letters in excel | Setting up and Configuration of Excel | |||
I have numbers instead of letters on my columns, why? | Excel Discussion (Misc queries) | |||
the letters across the top in excel have changed to numbers why | New Users to Excel | |||
ADDING NUMBERS IN COLUMNS ACROSS IN EXCEL | Excel Worksheet Functions |