Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
For some reason all my excel files now display columns as numbers rather than
letters. How can I change back to letters? Why are all my old files also now reading in numbered columns? |
#2
![]() |
|||
|
|||
![]()
This is a setting of Excel, not of your files.
ToolsOptionsGeneral, uncheck R1C1 Reference style -- Kind Regards, Niek Otten Microsoft MVP - Excel "garyflood" wrote in message ... For some reason all my excel files now display columns as numbers rather than letters. How can I change back to letters? Why are all my old files also now reading in numbered columns? |
#3
![]() |
|||
|
|||
![]()
Tools Options General
Clear the R1C1 check box "garyflood" wrote: For some reason all my excel files now display columns as numbers rather than letters. How can I change back to letters? Why are all my old files also now reading in numbered columns? |
#4
![]() |
|||
|
|||
![]()
Hi
tools / options / general - untick r1c1 reference style -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "garyflood" wrote in message ... For some reason all my excel files now display columns as numbers rather than letters. How can I change back to letters? Why are all my old files also now reading in numbered columns? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pivot table row vs column headings | Excel Worksheet Functions | |||
row numbers & column letters | Excel Discussion (Misc queries) | |||
How can I see column headings of hidden columns in Excel before u. | Excel Discussion (Misc queries) | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
My column headers are numbers | Excel Discussion (Misc queries) |