Blog Archive

Excel Tip: Replace formulas with values Quickly




Replace formulas with values using a simple wiggle trickFollow these steps


  1. Select all the cells that contain formulas
  2. Right click on the selection border (your mouse pointer changes to 4 sided arrow)
  3. Right click + Drag the selection a few cells away and drop them back at original place (ie wiggle)
  4. A menu appears. Select Copy here as values only.
  5. You are done

See the demo aside.

More fun & productive ways to use mouse in Excel


You can do a lot of powerful & useful things in Excel with mouse. Check out our Mouse shortcuts section.

 
Thanks to John for teaching me this wiggle technique.