Spreadsheet question

Factual Questions
1

I have a question about a spreadsheet for either Excel or Quattro pro (my comp has quattro pro, my husband’s has excel). I would like to create a simple file to mange my coupons with three columns: 1) name of the brand/ product; 2) amount of the coupon; 3) expiration date. Is there a way to link the three so that I can alphabetize according to the first column without losing the individual cells’ relationship (in other words, scrambling the name-amount-date relationship)? If I have to, I guess I could put it all in a single column, but that would make it 1) too messy, and 2) much harder to check the expiration dates and get rid of old ones.

Thank you for any advice - my budget needs the help!

2

The auto sort function in Excel will do this just fine. I can’t speak to Quattro Pro.

Just put the cell pointer in the first cell you want to sort of the first column you want to sort and hit the sort button. The only thing that will mess it up significantly is lots of blank cells. If you have that problem, highlight all the cells you want to sort and then hit it.

3

First highlight all the colomns you want sorted (all three), then try going into Data, then to Sort. It should give you the option of sorting by any one of the columns.

4

Sweet. I am definitely going to do this tomorrow when I’m not so tired that my eyelashes are hitting the keyboard. Thanks.

I’ll let you know when I’m a millionaire.

5

Just send the check. :wink: