How to Set Up a Totaling Spreadsheet in Excel. Understanding how cells behave in relation to one another is essential to getting the most out of Microsoft Excel. When you're working with multiple ...

Although a running balance is commonly maintained on the same Excel worksheet as the debits or credits, you can also keep a running balance with figures that reside on different Excel sheets.