Create a running balance in Excel that allows you to insert, delete, and move rows

Create a running balance in Excel that allows you to insert, delete, and move rows

26 April 2018

Calculating a running balance is a common and important spreadsheet task.

But inserting rows, deleting rows, and moving rows via cut and paste can introduce hard-to-detect errors in a running balance formula.

This article explains the problems with the basic running balance formula and provides two robust solutions.