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

If your data is in column A, then you could do this with a formula in each
corresponding cell in column B. If B1: =A1*1.05. Then copy the formula
down through the entire column.
Or you could type the number 1.05 in some empty cell, then copy it (ctrl+C),
select all the cells you need to adjust and Edit Paste Special, select
multiply and click OK.

"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?