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

Paste Special is an underrated tool in Microsoft Excel, with many people only using it to paste values. But it can do much more than that! Whether this is the first time you've heard of Paste ...

Master Excel with these 10 powerful functions. Learn time-saving tips and tricks to manage data efficiently and work smarter, ...

If you have a bunch of rows or columns in Excel that need to be updated with a math operation, instead of applying a formula or editing each cell, save some time by using Paste Special. The ...

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

To copy only the conditional formatting, move your mouse over Paste Special, then choose Paste Special from the new menu that appears. Click the radio button next to Formats and click OK.

Undo Paste Special operations the same way you undo any other Excel operation. You can repeat a Paste or Paste Special operation on a different range of cells as long as your selection remains active.

You can subtract multiple cells from one cell in Excel by using Minus sign, SUM function and Paste Special feature. Here is a tutorial on this.

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.