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!!
Tags: add cell values, cell values, paste function
 |  |  |  |  |  |  |
 |  |  |  |  |  |  |
 |  |  |  |  |  |  |
Posted on 30th August 2008 by Ashish Mohta , A tech blogger who writes 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 | Need more help? Ask your Questions at our Support Center
Free Email Subscription
Leave your response!