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!!
Posted on 30th August 2008 by Ashish Mohta , A Professional Tech blogger, Editor and Writer who talks about solving day to day problems of people who use computer. He also writes on How to use the applications like Office, PC tips, Online tools,Browsers and more. All posts by Ashish Mohta | Connect with me @ Twitter | Linkedin | Facebook | Stumble
Sign up for our daily email newsletter
i have a problem:( how can i apply them ? plese answear need help
Hey thanks a lot for the solution …. sorry for not giving you my original ID!!
Leave your response!