The Paste Special command under the Edit menu has a few operations that allow you to update a range of cell values all at once. They are Add, Subtract, Multiply, and Divide and they are in the Operation section of the Paste Special dialog box.
Assume you have a list of merchandise and corresponding prices. If you need to update all your prices to reflect a 5% increase, you can do so without using a helper column and a formula. To do this, put 1.05 in an unused cell (we’ll delete it later) and copy it.
Then select the range you want to update and choose Paste Special.
Choose the Multiply radio button
And the range will be increased by 5%
You can then delete the cell with 1.05 in it.