Co-Authored By:

##### Asked by: Ghiorghi Jennissen

science physics# How do I add and subtract columns in Excel?

Last Updated: 30th January, 2020

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

Click to see full answer.

In this way, 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:

Furthermore, how do you find the difference between two columns in Excel? **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.

Just so, 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.

How do I create a formula for multiple cells in Excel?

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.