I often find I need a way to copy a large range of cells to a new location but either keep the relative references as they are in the original or to tweak them by some other amount than the distance between the original range and the paste target range (e.g. simply to reference data one row further down from the original).

I think an option to paste without tweaking even relative references would be nice. With it the functionality I need could be emulated by copying to a new location without tweaking, moving down by one row (hence tweaking the references by the wanted amount) and copying to the target location without tweaking.

Another feature that would help is a way to tweak all relative references in the selection by a constant amount (e.g. 1 row up, or 5 rows down and 13 columns right).