Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with unwanted R1C1 References
In Excel i have done a group change with a simple formula (a1*b1 in cell c1)
and it comes up with the reference +RC[-1]*RC[-2] in all active sheets apart from the one i am using. I have tried to stop it, the help file only advises me to turn off R1C1 in options - it already is! Please help as i have to do this many times to over 40 worksheets! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-increment data source cell references when copying charts | Excel Discussion (Misc queries) | |||
How to auto-increment data source cell references when copying cha | Charts and Charting in Excel | |||
Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
Cell Reference's when Pasting | Excel Discussion (Misc queries) | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) |