| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row/Column Names
Got a strange one hadn't seen before.
Rows show as 1,2,3, but columns showing as 1, 2, 3.... not A, B, C, D Can't figure out how to out back as A, B, C, D..... How does that happen, is this a feature where you can change it, if so how? Good to know for future references, and if did change how to change it back. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row/Column Names
Tools/Options/General - uncheck the "Use R1C1 reference style" checkbox.
In article , Nadine wrote: Got a strange one hadn't seen before. Rows show as 1,2,3, but columns showing as 1, 2, 3.... not A, B, C, D Can't figure out how to out back as A, B, C, D..... How does that happen, is this a feature where you can change it, if so how? Good to know for future references, and if did change how to change it back. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row/Column Names
Thanks, hadn't see that before.
"JE McGimpsey" wrote: Tools/Options/General - uncheck the "Use R1C1 reference style" checkbox. In article , Nadine wrote: Got a strange one hadn't seen before. Rows show as 1,2,3, but columns showing as 1, 2, 3.... not A, B, C, D Can't figure out how to out back as A, B, C, D..... How does that happen, is this a feature where you can change it, if so how? Good to know for future references, and if did change how to change it back. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row/Column Names
On the toolbar, go 'Tool's 'Options', click the 'General' tab and uncheck
'R1C1 Reference Style'. Don't ask me how it got changed, it seems to happen occasionally for no apparent reason! Regards, Alan. "Nadine" wrote in message ... Got a strange one hadn't seen before. Rows show as 1,2,3, but columns showing as 1, 2, 3.... not A, B, C, D Can't figure out how to out back as A, B, C, D..... How does that happen, is this a feature where you can change it, if so how? Good to know for future references, and if did change how to change it back. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing A,B,C column names to other names | Excel Discussion (Misc queries) | |||
| How do I replace A, B, C, Column names, with my own names? | Excel Discussion (Misc queries) | |||
| how to check for recurrence of same names in column 1 and column | Excel Discussion (Misc queries) | |||
| Importing data to column from column with differnet names | Excel Discussion (Misc queries) | |||
| Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
Hybrid Mode
