Google Docs has a feature where if you have a reference to a data cell in a formula, and you cut the data from that cell and paste it in a new location, the reference in the formula is updated to point to the new cell location.
I'd like to be able to cut and paste my data without my formulas changing.
I've done some hideous things in the past involving the
INDIRECT() function to work round this feature, but it seems like there's got to be an easier way. Any suggestions?