Co-Authored By:

How to

**subtract columns in Excel**.To**subtract**2**columns**row-by-row, write a**minus**formula for the topmost**cell**, and then drag thefill handleor double-click the plus sign to copy the formula to theentire**column**.

Likewise, how do I subtract columns in Excel?

**Subtract numbers using cell references**

- Type a number in cells C1 and D1. For example, a 5 and a3.
- In cell E1, type an equal sign (=) to start the formula.
- After the equal sign, type C1-D1.
- Press RETURN . If you used the example numbers, the resultis-2. Notes:

**Here's one way you can use to compare two lists andidentifythe different or duplicate data.**

- Select the two columns that you want to compare.
- In the Home tab, click“ConditionalFormatting”.
- Click on “Highlight Cell Rules,” and thengostraight to “More Rules” and click on it.
- Here you will find many options.

Also, how do you subtract multiple cells in Excel from one cell?

**Subtract Multiple Cells Using Formula**

- Place the cursor in cell C1.
- Type the equal sign “=”
- Point the cursor to cell A1.
- Type the minus sign “-“
- Point the cursor to cell B1, make it an absolute referencebypressing the F4 key once.
- Press the Enter key.

Just select all the **cells** at the same time,thenenter the **formula** normally as you would for thefirst**cell**. Then, when you're done, instead of pressingEnter,press Control + Enter. **Excel** will add thesame**formula** to all **cells** in the selection,adjustingreferences as needed.