View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default Can I increase an entire column by a percentage?

In a blank cell insert 1.05 copy the cell, and then highlight the whole list
(not the whole column, just the cells you want to multiply). Select
Edit-Paste Special and then select multiply under Operation. Hit okay. All
selected values should be increased by 5%.

"KandyKane" wrote:

I need to increase an entire column by 5% (price list increase). Can I do
this with one individual forula? Do I have to do every row individually?