| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Excel help should explain how to change r1c1 to a1
Help describes a1 and r1c1 referencing but doesn't tell how to switch from
one to the other. Can anyone help? |
|
#2
|
|||
|
|||
|
toolsoptionsgeneral and uncheck/check R1C1 reference style
-- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "schlimgen" wrote in message ... Help describes a1 and r1c1 referencing but doesn't tell how to switch from one to the other. Can anyone help? |
|
#3
|
|||
|
|||
|
Click on Tools - Options - General tab. Check/Uncheck R1C1 reference style.
HTH Otto "schlimgen" wrote in message ... Help describes a1 and r1c1 referencing but doesn't tell how to switch from one to the other. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
|
Can you change the defaults for Excel |
Excel Discussion (Misc queries) | |||
Hybrid Mode
