Forums | MacLife
Wide is the new black
You are not logged in.
#1 2008-02-21 9:41 am
- Fatum
- Member
- Registered: 2004-06-04
- Posts: 89
Excel instead of Quicken
Being a college student it is wise to keep track of your accounts. I want to set up an Excel sheet for each of my accounts. Since I already have office rather than spending money on another program. Checking, Savings, Credit Cards, Student Loans, etc. I can't figure out how to make the cells all work together. Meaning that I want my balance cell to reflect "=sum(f5+d6)" then one cell down I want it to reflect "=sum(f6+d7)". Is there a quicker way to put this all in besides typing it in every cell? I can't figure out an easier way to set it up and I know there has to be. It would be nice if there is a way anyway. Thanks in advance.
Offline
#2 2008-02-21 10:08 am
- Fatum
- Member
- Registered: 2004-06-04
- Posts: 89
Re: Excel instead of Quicken
I feel stupid now. I didn't try the basic copy paste commands. Thought they would just copy the same formula but it copies it and pastes it relative to the location. That is cool. and found a fill down command also that easily fills in everything that you have highlighted.
Offline
