title: Excel (/ Google Spreadsheets) Don't change reference when cutting -other- cells
body: <p>I have a spreadsheet cell <code>A1</code> with the formula <code>=SUM($P$1:$P$6)</code>.
  Now when I cut the cells <code>P1:P6</code> and paste them to, say, <code>C1:C6</code>, it changes the formula inside <code>A1</code> to <code>=SUM($C$1:$C$6)</code>.</p>
  
  <p>Any way to keep the original reference in <code>A1</code> when cutting other cells?</p>