DECREASE ALL NUMBERS IN A COLUMN BY A PERCENTAGE

L

LoriK

I'm not knowledgable in excel. Can someone explain, in simple terms, how to
decrease all numbers in a column on a spreadsheet by a percentage? Thank you.
 
F

Frank Kabel

Hi
e.g. to decrease all by 5%:
- enter 0.95 in an empty cell and copy this cell
- select your values
- goto 'Edit - Paste Special' and choose 'Multiply'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top