Add line and retaining formulas

[Gideon15]

Hi there,

I was given the task of keeping track of the people that receive donations from a service from my church. I'm somewhat familiar with Excel, but I'm having trouble when it comes to adding in new members at the beginning of each month. I've attached a blank copy of the spreadsheet layout that we use to keep track of it and was hoping someone could explain to me how I can add in new members. For example, say we have 200 or so members and I need to insert a new line between 149 and 150, how do I add a new line, and push the rest of the data down, allowing for all the information that follows it to be changed on the other workpages that correspond to it? The corresponding pages are in Red and I use the Demographics page to add new users apparently.

Any help would be greatly appreciated! Thank you

Edit: For some reason, it's still 8MB, so I'll just use Mediafire to upload it

http://www.mediafire.com/?a1xyfq8ie154grg

[npamcpp]

Did you mean to attach a file? It didn't quite make it.

You can right-click the row header and select "Insert" from the context menu to insert a new row in a spreadsheet.

If your data is formatted as a table (using Insert Ribbon > Table) then all formulas and formatting will automatically be applied to the new row, as well as to any row of data that is added at the bottom of the table.