Tip of the Day | Friday 10 July 2026

This tool lets you move a selected range to a new location while converting any formulas within that range into their calculated values, just like using Paste Special > Values.

Unlike Excel's standard Cut and Paste, which automatically updates any dependent formulas (formulas referencing the moved cells), this tool leaves those references unchanged. This makes it easy to relocate data without having to worry about unexpected formula adjustments elsewhere in your workbook.

Starting this tool