Editing Excel Spreadsheet by Adding and Deleting Line Accounts in the Regular Accounting Spreadsheets

Deleting Line Accounts in the First Worksheet (Gl-Jan)

1. In the first worksheet(GL-Jan), highlight the rows you need to delete with the desired amount of line accounts. (Hint: Take the bottom line accounts so you will not have to reset the balance column formulas again. If you need to take out one of the income accounts, you will need to reset the balance formulas again. See this page for those required steps), on the Home tab, in the Cells group, click the drop down arrow next to Delete, and then click Delete Sheet Rows.
2. Now you need to fix the totals.
3. Select the Total debits (expenses) cell, hit F2, Backspace, to erase all of the + #REF!, hit enter.
4. Repeat for the credit (income) cell.
5. Repeat steps 2 and 3 for the remaining fund accounts.

Deleting Line Accounts in the Monthly and Annual Report (Jan)

1. In the Jan monthly report, select all the rows with the #REF!s, delete.
2. If it took out the last line under expense, you will need to put back the borders, go to the home tab if not already there, in the font group, click on the borders arrow and go down to double border...or whatever border you want), click where you want them.
3. Repeat steps for the annual report.

Not bad...huh?

Adding more line accounts isn’t too difficult either...just takes some time.

Adding Line Accounts in the First Worksheet (GL-Jan)

1. Let’s practice by adding another expense account (you can always delete it or use your back arrow to get rid of it later).
2. Select rows 109-117 (expense #10), on the home tab, in the cells group, click on insert arrow, and go to Insert Sheet Rows.
3. Yikes! What a mess! But don’t worry...we are going to fix it now....
4. Select rows 118-126, click copy, select cell A109, hit enter...better huh!
5. Rename and re-color new expense account.
6. Now to fix the balance column. Select the top cell in the new expense acc. in the balance column.
7. Hit F2, hit backspace till you come to the plus sign..then click on last cell in the account above it. Hit Enter.
8. Do the same thing for the last expense account.
9. When you are finished adding accounts, you will need to add them to the Total debits (expenses) cell at the bottom. Hit F2, then the plus sign and then click on the red debit total...if you just added 1 account hit enter...if you added more...hit the plus sign and pick them all up before hitting Enter. Do the same for the Total credit (income) cell.
10. Repeat for remaining Fund accounts