Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying non-contiguous formulas
I want to copy down formulas refering to ranges of 25 rows (e.g. sum rows
1-25, sum rows 26-50 etc.) but when I copy the formula down, it only adds one to each reference, not 25 (even when I've supplied several correct formulas). Are there any tricks for getting around this? I have to copy the formula down 100 times and don't really want to type each one. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Formulas | Excel Discussion (Misc queries) | |||
copying formulas | Excel Discussion (Misc queries) | |||
Copying Formulas | Excel Discussion (Misc queries) | |||
Copying Formulas | Excel Discussion (Misc queries) | |||
Excel copy formulas using non contiguous range | Excel Discussion (Misc queries) |