How Do I Make a Book Ledger Template in Excel for Mac?

Create a checkbook ledger template to suit your banking needs.

With Microsoft Excel 2008 for Mac you can easily create a pre-formatted checkbook ledger template that will allow you to create and manage multiple checking accounts from the convenience of your computer.

Instructions

1. Click on the "Sheets" tab located below the Formatting toolbar of a new Excel workbook.

2. Click on the "Accounts" button; six pre-formatted ledger sheet icons will appear.

3. Click on the "Checking Ledger" icon (the third one).

4. Enter the account name and number at the top of the sheet.

5. Click on "Save" from the standard toolbar.

6. Name the file as desired, e.g., Checkbook_Ledger.

7. Click on "Format" and select "Excel Template (.xltx)"; saving the file as a template will automatically add it to the "My Templates" folder located in the Microsoft Projects Gallery for future use.

Tips & Warnings

• If your computer is not secure, consider using an alternative account number identifiable only by you.

References

• YouTube: Excel 2008 Ledger Sheets