Subtraction for Whole Column in Excel (with 5 Examples)

Below is a dataset that includes income and expenses.

Method 1 – Subtraction of Cells Between Two Columns in Excel

Steps

• Select cell D5.

• Enter the following formula in the formula bar:
`=B5-C5`

Â

• Press Enter to apply the formula.

• Drag or double-click on the Fill Handle icon down the column. Then we get all the required savings.

Read More: How to Subtract Two Columns in Excel

Method 2 – Subtraction of a Specific Value in Excel from a Whole Column

Steps

• Consider an individual value. Here, we take the value as 40, which needs to be subtracted from the whole column.
• Select cell E5.

• Enter the following formula in the formula bar:
`=D5-40`

• Press Enter to apply the formula.

• Drag or double-click the Fill Handle icon down the column. On one occasion, there is a negative saving, which means expenses are greater than income.

Method 3 – Using the Paste Special Tool to Subtract a Certain Value from a Whole Column

Steps

• Set a specific value as a fee. Here, we set \$40 as a fee and copy it.
• Copy column D to column E; otherwise, Paste Special will rewrite the previous column.
• Select column E.

• Go to the Home tab and click Paste from the ClipboardÂ group.

• Select Paste Special from the PasteÂ option.

• A Paste Special dialog box will appear. Select All in the Paste option, and select Subtract from Operation.
• Click on â€˜OKâ€™.

• This will subtract a particular value from column D.

Method 4 – Using Absolute Cell Reference for Subtraction in Excel from Whole Column

Steps

• Select cell E5.

• Enter the following formula in the formula bar:
`=D5-\$G\$5`

• Press Enter to apply the formula.

• Drag or double-click on the Fill Handle icon down the column. That will provide the result of subtraction. This also provides a dynamic solution: If you change the fee, it will automatically change the result.

Method 5 – Subtraction of Multiple Excel Cells from One Particular Cell

Steps

• Enter the value in cell B5.
• Select cell D5, where you want to put your result.

• Enter the following formula in the formula bar. Here, the â€˜\$â€™ sign means this cell must be fixed in all the remaining cases.
`=\$B\$5-C5`

• Press Enter to apply the formula.

• Drag or double-click on the Fill Handle icon down the column. Here, cell B5 is fixed in all the calculations, which is what we want.

Related Articles

<< Go Back to Subtract in Excel

Get FREE Advanced Excel Exercises with Solutions!
Durjoy Paul

Durjoy Kumar, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, is a dedicated contributor to the ExcelDemy project. His substantial contributions include crafting numerous articles and demonstrating expertise in Excel and VBA. Durjoy adeptly automates Excel challenges using VBA macros, offering valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, C, C++, C#, JavaScript, Python Web Scraping, Data Entry... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF