This month’s column walks you through all the special ways you can paste text, data, and even application capabilities in Excel.

Use Excel's Paste Special feature to calculate multiple values against a data range, at the same time. You can make the process even more efficient with keyboard shortcut combinations.

VIDEO: "Paste Special" in Excel does much more than just paste values - it can help you sort data too.

Excel's Paste Special function can do just that by first copying the value for which to base the increase and then increasing the existing data in place.

Learn how to remove formula in Excel and keep the text. Use Paste Special option to delete formulas without removing values in Excel.

How to Lock Numeric Values in Excel. Microsoft Excel is a powerhouse when it comes to calculating numbers. With its vast assortment of functions, you can construct formulas to derive virtually any ...

VIDEO: "Paste Special" in Excel does much more than just paste values - it can help you sort data too.