How to subtract in different cells If you have numbers located in different cells in your spreadsheet that you want to subtract, you can do so by using cell references and a formula.

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.

Like we already mentioned, there’s no actual command in Excel for subtracting values, you have to use an operator in a formula. That said, we can create individual formulas in cells.

Microsoft Excel's spreadsheet design allows you to quickly calculate values separated into two columns and replicate this calculation without having to manually recreate the formula for each row ...