Tuesday, January 10, 2017

Create a Checkbook Register in Microsoft Excel

You can download a free check register directly from Excel.  Here’s how:
1    1.  Open Excel.
2.  Click File > New
3.  In the search box, type: “check register” and then press ENTER.
4.  When the results of your search are displayed, select one.

5.  Click Create.
6.  Save the register to a location of your choice.

You now have an electronic check register that will automatically calculate your balance.

IMPORTANT NOTE: Enter your current balance in the first Deposit field so as not to delete the formula in the Balance column.
 
If you want to print the last few lines of the register to put in your checkbook to use while you are away from your computer, do this:
1.     Select only the data you want to print.
2.     Press Ctrl+p to view the print options.
3.     Select “Print Selection” (instead of “Print Active Sheets”)
4.     Click “Print”.