insert column next to your prices. assuming data starts in "A1" in "B1"
write: =A1*.95 This will give you your price less 5%. Copy down the
column. If you want to replace values in your original price column with
new price, click on column "copy" then highlight original column "paste
special" and "values"

"S1L1Y1" wrote:

I would like to ask. I have a pricelist of about 300 items, and I want to
deduct 5% from the cost all items. Is there a way to do it at once or do I
have to go to each one separately?
Sol