Modify and Customize the Monthly and Annual Reports in the Your Free Spreadsheet Software

Deleting Fund Accounts on GL:

1. Select the columns that you want to delete. (Click on the letter of the column you want to delete and hold the left button on your mouse and highlight all columns you want to delete)
2. You can either right click on further down in the worksheet and click on Delete or….on the Home tab, in the Cells group, click the drop down arrow next to Delete, and then click Delete Sheet Columns.
3. Now correct your formulas in the Balance column: select (click on) the last cell in row 10.
4. Click the equal sign on your keyboard, select beginning balance in Fund Account 1 (E10), then hit plus sign and click on next beginning bal, repeat for each remaining fund beg. bal. then hit Enter.
5. Select the next cell in the balance column (row 11), click the equal sign, select the credit cell in fund acc#1 (E11), hit plus sign and select next credit cell in fund acc#2, hit plus again and repeat for each fund, then hit minus sign select debit cell in Fund Acc#1 (D11), minus again and select next debit cell, repeat for each fund, then hit plus and beginning balance cell in row 10, hit Enter.
6. Select the last cell in row 11, again, Notice the little black box on the bottom right corner of that cell. That is your “Fill Handle”. Put your mouse pointer over it. Notice how the pointer goes from a fat white plus sign to a skinny black plus sign. That means your fill handle is ready. Click and pull down to row 16.
7. Select cells 11-16 in balance column, click copy and select last cell in row 21 and hit enter.
8. Select last cell in row 21 again, hit F2, Backspace, 2, and type 16, then enter.
9. Now the rest are easy…just select balance cells 21-26, click copy, then enter.
10. Repeat for the rest of the accounts.
11. Whew! One worksheet done...only 11 more left! Repeat all steps for the rest of the 11 months.

Deleting Fund Accounts on Reports:

1. Select the columns that you want to delete. (Click on the letter of the column you want to delete and hold the left button on your mouse and highlight all columns you want to delete)
2. You can either right click on further down in the worksheet and click on Delete or….on the Home tab, in the Cells group, click the drop down arrow next to Delete, and then click Delete Sheet Columns. Formulas in Total column automatically adjusted except for the line accounts we deleted.
3. Repeat for all monthly, quarterly, and the annual report.

That was alot easier than the General Ledger sheet huh :-)

Want to delete or add more line accounts?

Click here for step-by-step instructions on deleting or adding line accounts.

Return to Home from "Free Spreadsheet Software"