spot_img

Updating Values Without Using Formulas

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

We 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

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

Paste Special

Click Multiply and OK.

Wow! Values are updated… without any formula.

Sales Rep Excel update

Every value is now doubled.

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

Template

You can download the Template here – Download
spot_img
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial