Read More: Subtraction for Whole Column in Excel (with 5 Examples) ➤ After that, we will select the cells in the Salary column from D5 to D12, and we will right-click.įinally, we can see that the salary column contains cell values that subtract $300 from them. ➤ First of all, we will right-click on cell I5. In this method, using a paste special feature we will subtract the value in cell I5, which is $300 in the Health Insurance column from the Salary column cells. Method-2: Paste Special Feature to Subtract Single Cell from Multiple Cells Read More: How to Subtract Columns in Excel (6 Easy Methods) ➤ We will drag down the formula with the Fill Handle tool.įinally, we can see all the savings in the Savings column. D5-E5-F5-G5 → Subtracts cells E5, F5, G5 from cell D5.
