How to quickly add, multiply, subtract and divide 2 Excel columns

Here is another quick tip from excels special paste function. If you want to add , multiply, devide or subtract 2 columns in an excel sheet quickly using the special function is the only way. All you need is do a copy from a column and then right click on top of cell you want to perform the addition or whatever you want. Then just paste its specially.

  • Select the cell values of which you want to other column. Now select the other set of columns where you want to add.
  • Right click  and the special paste
  • Select ADD . ok.

This will add the column values. have fun!!



Please enter your comment!
Please enter your name here