Copying values changes formulas that reference these values

English
#1

Let’s say I have column A containing values (A1: 4, A2: 5), and column B with formulae that reference column A (B1: =A1 * 2, B2: = A2 * 2). I select cells A1:2, cut (Ctrl-X), then paste them into A2, so that value from A1 is in A2, and value from A2 is in A3.
What I expect: that formula in B1 is now referencing an empty cell (A1) and has value 0, formula in B2 references A2 and has value 8
What happens: formulae in B column get adjusted to refer to the exact same values

IMHO this is a usability blunder: copying/pasting values should not affect formulae in unrelated cells. At the very least, I’d like to know if there is a way to get my expected behaviour; paste special → paste values didn’t help

#5

With Ctrl+X you are not copying/pasting but cutting/pasting and then adapting references to the pasted target cells is exactly the expected behaviour.

#2

NO, its not a usability blunder …the most users want exactly that, if the move Cells around…insert Rows… or Columns .

use for Example:

=INDIRECT("A1")*2

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.