Alter all my price lists

I am looking for a way to alter my wholesale price list to retail price list without going through ever cell and changing it. I just need to add 55% to all cells at once. Can any body help.

There's more than one way to do this but here's a suggestion. Assuming prices are in column A, in column B enter a formula =A1*155%. Copy this down the column. Once you've done that, highlight those cells in column B and copy paste special values into column A. Then you can just delete the formula in column B. Job done.