Need to add same value to every cell...Is that doable?

B

Brita

I have a spreadsheet that is like a price list. I need to
add an amount to every cell. Is there an easy way to do
that & have it calculated for me instead of manually
calculating it & typing it in?
 
R

Ron de Bruin

Hi Brita

Enter the amount in a empty cell on you sheet
Copy this cell
Select all the cells
Right click on them and choose Paste Special >Add
 
B

Brita

Thanks. I wasn't clear. My fault. I have cells with
values in them already. I need to add 50 to each one.

THANKS!
 
Top