Phone 1300 793 951 or visit

Odyssey Training Logo
Microsoft Excel logo

Excel tutorial: pasting values with drag and drop

Pasting the values from a formula (so that the numbers never change) has always involved several steps. Often you want to calculate an answer, but store the number, not the calculation.

However, with this tip, you can easily replace your formulas with the calculated values almost instantly

  • Create the following data and formulas:

Equals sign A2 multipled by 10 percent

  • Copy your formula down column B.

Now, let’s say you want these GST amounts to be the calculated value, not a formula.

  • Select the formulas.
  • Point to the edge of the selected range with your mouse, until the mouse pointer turns into the four sided arrow pointer.

Selected range

Here's the trick. Click and hold down the RIGHT mouse button while you drag away, then drag back over the same range.

A menu appears:

Copy here as Values only

  • Select Copy Here as Values Only.

You have turned the formulas into hard-coded number, and they won't update again.

This tip was provided by Jane Pettigrew, one of our expert Microsoft trainers. Learn more by attending our beginner to advanced level Microsoft Excel training.

Our Training Courses

- +