One size does not fit all when it comes to spreadsheets. Learn some basic excel spreadsheet tips that will help you customize your accounting spreadsheets to suit your 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.
The manual spreadsheet is definitely the easiest spreadsheet to customize. It is not linked together as much as the automatic spreadsheets, so it is simpler to modify.
Note: The following instructions are conformed to the 2007 Excel 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 spreadsheets.
So the column, row, or cell numbers in your version may not match up
with the numbers in the step-by-step guides.
List of Instructions for Modifying the Manual Accounting Spreadsheets:
The automatic 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 Automatic Accounting Spreadsheets:
Note: 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.