Skip to content
Back to template gallery
Microsoft Excel
Microsoft Excel

How to subtract in Excel

Learn how to subtract cell values in Microsoft Excel by entering data and creating a basic subtraction formula. This step-by-step tutorial guides you through inputting numerical values into cells and writing a formula to calculate the difference. By following these steps, you will be able to perform basic subtraction operations to manage your spreadsheet data efficiently.

Accounting & Finance
5 steps 2 min Community template
1

Open or Navigate to Excel window

Open Microsoft Word or switch to the active Excel window on your taskbar to begin editing your worksheet.

excel.cloud.microsoft
Open or Navigate to Excel window
2

Click on cell and add any value

Click on cell in the spreadsheet grid to select it, then type any number. For example I enter 45

excel.cloud.microsoft
Click on cell and add any value
3

Click on another cell and add value for subtract

Click on another cell to select it, then type the value you want to subtract from your first number. For example I enter 30

excel.cloud.microsoft
Click on another cell and add value for subtract
4

Select Cell D1 to Enter Formula

Click on cell D1 where you want the result to appear, then type =B1-C1 and press Enter.

excel.cloud.microsoft
Select Cell D1 to Enter Formula
5

View the Subtraction Result

Press Enter to calculate the formula and display the calculated difference in cell D1.

excel.cloud.microsoft
View the Subtraction Result

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.