Deduct a percent from list

[S1L1Y1]

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

 

[Jim Thomlinson]

Put .95 in a cell. Copy that cell. Select the range you want to modify.
Choose Edit -> Paste Special -> Select Multiply.

 

[twototango]

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"

 

[Bob I]

put .95 in a cell Copy it, select the 300 items, Edit, paste special,
Multiply.