Deleting or Adding Lines to Spreadsheets

Deleting or adding extra lines in the income and expense accounts is not too difficult. See step-by-step instruction below:

Deleting rows:

Deleting or Adding Lines to Spreadsheets
  • Highlight the rows you would like to delete. Hint: Don’t delete the first row in each account—it’s what connects it to the row above it.
  • Click delete.
  • Click in the cell above the cell that has #REF! in it in the balance column.
  • Grab hold of the “Fill Handle”. Your “Fill Handle” is a little box in the lower right corner of your cell. 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
  • Holding your left button down on your mouse, pull the fill handle down to the cell underneath it (the one with the #REF in it)
  • Let go of your left button on your mouse.
  • Your formula is ready.

Click on image above for more details.

The Spreadsheet Package includes a workbook for tracking contributions, an automatic accounting workbook for tracking up to 5 funds,10 income accounts and 40 expense accounts and several more accounting workbooks. It also includes a Word document with 3 customizable contribution statements.Click here for more information or purchase now for $19.95

Adding rows:

  • Click on the row where you want to add rows above it. Tip-choose the bottom or middle rows-not the top row)
  • Right click and click on insert or on the home tab, in the cells group, click on the drop-down arrow on the right side of Insert, and go to Insert Sheet Rows.
  • Click on the cell directly above new rows.
  • Pull down your fill handle to bottom row of THAT account.
  • Now check your formulas. Click the balance cell on each newly formed row and hit F2. Make sure the last number in the formula is the cell before it. If not...backspace to plus sign and click on the cell directly above it or the last cell in the account above it.

If you want to DIY your payroll, I highly recommend you look at using Gusto! It is very user friendly and their support is awesome! Plus they know how to set up and maintain payrolls for churches and nonprofit organizations.

Note: I am a "partner" of Gusto, but as I have told you before ... I never recommend anything that we or our clients have not tried and love =)

Share this page:
Enjoy this page? Please pay it forward. Here's how...

Would you prefer to share this page with others by linking to it?

  1. Click on the HTML link code below.
  2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.