| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I change my cell reference columns from number to alphabet?
Some how my columns have changed from alphabet to numbers and I don't know
how to change the settings. For example column A is no Column C1. How do I change the column settings back to the original alphabetic reference? |
|
#2
|
|||
|
|||
|
How do I change my cell reference columns from number to alphabet?
Tools/Options/General tab, deselect R1C1 notation checkbox
"Carol A. Williams" <Carol A. wrote in message ... Some how my columns have changed from alphabet to numbers and I don't know how to change the settings. For example column A is no Column C1. How do I change the column settings back to the original alphabetic reference? |
|
#3
|
|||
|
|||
|
How do I change my cell reference columns from number to alphabet?
Thank you Bob! Your response was timely! I am still mystified, however, as
to how it changed! We recently had a system upgrade and the web-based spread sheets have numbered columns, but I am not sure if this is how my columns changed. I do know that I did physically make the changes. Once again, thank you very much! "Carol A. Williams" wrote: Some how my columns have changed from alphabet to numbers and I don't know how to change the settings. For example column A is no Column C1. How do I change the column settings back to the original alphabetic reference? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) | |||
Linear Mode
