Multiply column values by one number
I have a decent sized spreadsheet (500+ rows) with two columns, one for a product item number, and the other the product price. I need to multiply every price in that particular column by 1.20. Is there a way I can update the price values in that column all at once, instead of having to go through it one at a time?
|