Excel Spreadsheet Tips to Customize Your Free Excel Spreadsheets

Learn some basic excel spreadsheet tips that will help you customize your accounting spreadsheets to suit your personality and particular needs.



In the following pages, you will learn how to make attractive headers, add and delete columns, add and delete rows, and add and delete accounts.

Note: I have excel 2007 and these instructions are conformed to that edition; however, even though the editing tools are not in the same place in the 2003 edition...the step-by-step instructions are general enough to use with any Excel version.

Note: I have made multiple changes to my free spreadshets. So the column, row, or cell numbers in your version may not match up with the numbers in the step-by-step guides.

If you don't have the time to modify the spreadsheets yourself...I can do them for you.

List of Instructions for Modifying Basic Accounting Spreadsheets:

• Click here to add and delete fund accounts on general ledger.
  
  
• Click here to add or delete fund accounts on the monthly and annual reports and to add and delete line accounts.

The regular spreadsheet can also be modified; however, because each page is linked to at least one previous sheet it is much more difficult to customize. So, if you have the time and the patience...

Here is a List of Step-By-Step Guides to Modify the Regular Accounting Spreadsheets:

• Click here to customize your headings.

• Click here to delete or add rows in the income or expense accounts.

• Click here to delete fund accounts in the GL and reports.

• Click here to delete or add line accounts(Revenue and Expenses).

• Click here to add additional fund accounts to the general ledger.

• Click here to add additional fund accounts to the monthly and annual reports.

• Click here to add quarterly reports to your spreadsheets.

• Click here to protect your data

Notice: If you had any problems receiving or downloading your free spreadsheets, please check the FAQ page. Hopefully you will find the solution to your problem or question. (If not, it will tell you where to submit your question/problem.)

Return to Home page from Excel Spreadsheet Tips