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


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.

Featured Posts
Posts Are Coming Soon
Stay tuned...
Recent Posts
Archive
Search By Tags

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions