MS Excel Tip: The difference between Cutting and Copying a Formula

July 5, 2018

 

 

Cut (ctrl+X), Copy (ctrl+C) and Paste (ctrl+V) are probably some of the most frequently used functions across the computing world and are particularly useful in the Excel environment. When applied to cells that have formula though, one needs to be aware of how the Cut and Copy functions differ.

When Copying and Pasting formula, the cell references change to be relevant to the new location of the pasted formula. If the original formula referenced the 2 cells to the left, then the new formula will reference the 2 cells to the left of its new location.

When Cutting and Pasting a Formula, the cell references in the formula do not change and the resultant value will stay the same. In effect, the location of the original Formula has simply been changed.

 

Share on Facebook
Share on Twitter
Please reload

Featured Posts

Excel Tip – Using the Format Painter multiple times

November 20, 2019

1/1
Please reload

Recent Posts