To balance your checkbook in Excel, your best method is:
Copy your check amounts into Excel so that you'll have a neat printout to work on.
Use Excel to check your arithmetic.
Click Validation on the Data menu.
Download the Checkbook Register template from Templates on Microsoft Office Online.