Paste Special in Excel
The Paste Special command has a number of useful tools built into it. Besides allowing you to Paste values, it also allows you to transpose lists (columns to rows or rows to columns), multiply, add, skip blanks and paste links.
Views: 626 | | by Sean
View this tutorial