View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default Want to Increase Prices by Percent

one way

1.. In an empty cell, enter the number that you want to multiply by.....
1.10
2.. Select that cell, and on the Edit menu, click Copy.
3.. Select the whole range of numbers that you want to multiply.
4.. On the Edit menu, click Paste Special.
5.. Under Operation, click Multiply.
6.. Click OK.
7.. Delete the content of the cell entered in the first step.
Greetings from New Zealand



"Shirley" wrote in message
...
New to this. Am using Office-Excel 2000. Have entered three columns of
prices
for company (List, Dealer, Distributor). Prices will increase next month.
How do I increase all rows (example C3-C50) by 10 percent?
Will need to do this for all three columns.
--
ShirleyF