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 ...

How to subtract in Excel using cell references You don't have to subtract numbers in a single cell; you can also set up a formula that will subtract the values stored in multiple cells.

Create a formula to add or subtract data in Excel by using cell numbers Above, we have seen a simple method to create a formula to add or subtract data in Excel.

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

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

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.