| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Columns in Excel are numbers instead of letters, how do I change .
Recently when I open Excel, both the rows and columns are numbers. They are
referenced R1C1, instead of A1 for row one column one. When I use Excel on another computer and then open that saved file on mine, then it is fine. The problem occurs when I attempt to open a new spreadsheet from my cpu. Any suggestions? I have obviously changed a setting somehow. Thank you. |
|
#2
|
|||
|
|||
|
Click Tools Options General tab
Uncheck "R1C1 reference style" OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "barnes76" wrote in message ... Recently when I open Excel, both the rows and columns are numbers. They are referenced R1C1, instead of A1 for row one column one. When I use Excel on another computer and then open that saved file on mine, then it is fine. The problem occurs when I attempt to open a new spreadsheet from my cpu. Any suggestions? I have obviously changed a setting somehow. Thank you. |
|
#3
|
|||
|
|||
|
Go to ToolsOptions and on the General tab, uncheck the R1C1 Reference Style
checkbox. -- HTH RP (remove nothere from the email address if mailing direct) "barnes76" wrote in message ... Recently when I open Excel, both the rows and columns are numbers. They are referenced R1C1, instead of A1 for row one column one. When I use Excel on another computer and then open that saved file on mine, then it is fine. The problem occurs when I attempt to open a new spreadsheet from my cpu. Any suggestions? I have obviously changed a setting somehow. Thank you. |
|
#4
|
|||
|
|||
|
Tools=Options=general tab, unclick R1C1 Reference Style.
-- Regards, Tom Ogilvy "barnes76" wrote in message ... Recently when I open Excel, both the rows and columns are numbers. They are referenced R1C1, instead of A1 for row one column one. When I use Excel on another computer and then open that saved file on mine, then it is fine. The problem occurs when I attempt to open a new spreadsheet from my cpu. Any suggestions? I have obviously changed a setting somehow. Thank you. |
|
#5
|
|||
|
|||
|
Thank you very much!
"Max" wrote: Click Tools Options General tab Uncheck "R1C1 reference style" OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "barnes76" wrote in message ... Recently when I open Excel, both the rows and columns are numbers. They are referenced R1C1, instead of A1 for row one column one. When I use Excel on another computer and then open that saved file on mine, then it is fine. The problem occurs when I attempt to open a new spreadsheet from my cpu. Any suggestions? I have obviously changed a setting somehow. Thank you. |
|
#6
|
|||
|
|||
|
"barnes76" wrote:
Thank you very much! You're welcome ! -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| New to Excel - I want to add a few columns across (P and Q)...How? | New Users to Excel | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
| How do I change the columns in excel back to alpha characters? | Setting up and Configuration of Excel | |||
Linear Mode
