Updating cells with no formula

[DShack]

Hello Everyone,

Is there a way to update cells that have no formula in them (just pasted values) easly by 5%.

Thanks

 

[VoG]

Type 1.05 into a spare cell and copy it.

Select the cells to be updated, Edit > Paste Special. tick Multiply, click OK.

 

[DShack]

Thank you so much. This was a huge help

 

[Rick Rothstein]

Type 1.05 into a spare cell and copy it.

Select the cells to be updated, Edit > Paste Special. tick Multiply, click OK.

An easy way to select the cells, especially if there are a lot of them and the formulas are mixed in with the constants, is to select the columns you want to process, press the F5 key to bring up the "Go To" dialog box, click the "Special" button, select the "Constants" option button and click OK.