You can subtract multiple cells in Excel by using the Paste Special feature. But this trick works only if you have to subtract only one value from multiple cells. Let’s see how to do that.

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.

In our case, we have to sum the data in the cells B2 to B6, hence, the formula is: =B2+B3+B4+B5+B6. Similarly, you can create a formula to subtract data in Excel.

To multiply certain numbers or cell values in Excel, you’ll need to use the * (asterisk; also called "star") operator. To multiply two numbers in Excel, you can type the formula =number1*number2 in ...