How To Calculate Running Balance In Excel Check Register

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More than...Less

Allow'southward say you may want to run across a running balance of items that you purchase so that you lot don't exceed your spending limits. You tin can use a running balance to sentry values of items in cells add together up equally you enter new items and values over time. To summate a running balance, apply the post-obit procedure.

Annotation:A running balance differs from a running total (also called a running count), in which you watch the number of items in a worksheet add up as you enter new items. For more than data, see Calculate a running full in Excel.

Set a worksheet similar the following instance.

Case information:

	A	B	C
1	Deposits	Withdrawals	Residue
two	one thousand	625	=SUM(A2-B2)
3	1245	740	=SUM(C2,A3-B3)

Click anywhere exterior cell C3 to run across the calculated full.
To maintain the running balance, add a row for each new entry by doing the following:
1. Type the amounts of your deposits and withdrawals into the empty rows directly below the existing data.
  
  For instance, if you were using the example above, yous would type the deposits into A4, A5, and so on, and the withdrawals into B4, B5, and so on.
2. Extend the running balance formula into the new rows by selecting the concluding prison cell in the balance cavalcade and then double-clicking the make full handle.
  
  For instance, if you were using the example above, you would select cell C3 and then double-click its fill handle to extend the formula into all new rows that comprise deposit and withdrawal values.

Need more aid?

You tin can ever inquire an adept in the Excel Tech Community or get support in the Answers community.

Demand more help?