The default settings for the accounting number format, which is one of 10 formatting choices in Excel, are to include two decimal places in the number entered into the spreadsheet and to display ...

Excel will calculate the total of all the cells in that range. Format the cells to use accounting style. Click and drag on the spreadsheet to select all of the cells with monetary values.

Create a new conditional formatting rule As you can see from the list above, Excel offers a quick and convenient way to add conditional formatting to your spreadsheets.

The article How to Balance Your Checkbook Using an Excel Spreadsheet originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

I discovered artificial intelligence tool GPT Excel in my quest to cut down on all the busywork it takes to create and update spreadsheets.