Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 reference style
I know how to get rid of it now - maybe not permanently, it seems to come
back as a default at times. But does anyone know what it's actaully used for? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 reference style
Tools|options|General Tab|check/uncheck R1C1 Reference style.
Believe it or not, some people like working this way! (It is a nice way to compare formulas that should be the same, though.) And excel picks it up from the first workbook you opened that session. You may just be unlucky enough to open a workbook that was saved (by someone else???) in R1C1 reference style. Peg P wrote: I know how to get rid of it now - maybe not permanently, it seems to come back as a default at times. But does anyone know what it's actaully used for? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
R1C1 reference style
Well, for some kinds of applications it is just easier to understand.
If you have a financial projection, one row per month, 200 columns wide, and the first cell of each row, the start value, is the end value of the month above, you get a formula like =EndValueMonth R[-1] (Endvalue of the row above) Which is, I think, easier to understand than =EndValueMonth 14:14 (different in each row) I must admit though that, since this format (which used to be my favorite!) is so rarely used, I tend to give up. -- Kind regards, Niek Otten "Peg P" <Peg wrote in message ... I know how to get rid of it now - maybe not permanently, it seems to come back as a default at times. But does anyone know what it's actaully used for? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Change GETPIVOTDATA cell reference to A1 style | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
R1C1 reference | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |