How to Update Values Without Using Formula

I show you how to update value in cells without using formula.

Data preparation

I prepared a Sales Report.

Sales Rep Excel

But I did it wrong. It should be doubled. How to correct it without formula?

Type 2 into cell and copy it.

Sales Rep Excel correct

Next select values.

Sales Rep Excel select

Updating values

Then right click and choose Paste special. Dialog box appears.

Paste Special without formula

Click Multiply and OK.

Wow! Values are updated... without any formula.

Sales Rep Excel update without formula

Every value is now doubled.

Be careful using this trick. You can't undo this operation after saving file.

How to Change Formula to Value?

You can also want to change formula to the value. Exchanging formula to value is very easy, and an act that can be easily performed. It is what you will learn in this article.


Layout the values.

Exchange Formula values

Note: These values would be the source that make creating formula a possibility. You may skip this step if you have formula available.

Click on an empty cell (1), and create the formula (2), any formula of your choice.

Exchange Formula to Value create formula

Click on that value showing (1), press CTRL + C to copy it, then right click on the mouse on an empty cell (2), paste special (3), and choose paste values (4).

Exchange Formula paste values

You can also use keyboard shortcut ALT + E + S + V

In conclusion, in this case false is the value, which means we have used the formula to get the value that originated from the value we created in step 1.