How to Prepare a Grocery List on Your Laptop Computer: 5 Steps

Placing a grocery list on your PC will allow you to track your costs and keep a running balance. This procedure will work for a spreadsheet created in Microsoft Excel™. This will teach you how to set up a dynamic grocery list, not how to use a spreadsheet program.
STEPS

1

CREATE YOUR HEADINGS.
Cell A1 should be titled "Item".
Cell B1 should be titled "Price".
Cell C1 should be titled "Quantity".
Cell D1 should be titled "Total/Item".
Cell E1 should be titled "Grand Total".

2

FORMAT COLUMNS B, D, AND E FOR TWO DECIMAL PLACES IN CURRENCY.
In cell D2, enter the formula " =B2C2 "


In cell E2, enter the formula = D2


In cell E3, enter the formula = E2 + D3


In cell D2, grab the bottom right hand corner. You should see the icon change to a cross. Without releasing, pull down about 100 spaces. If you move to the right, just move back over to the "D" column. This will put the formula in all of the places you made dark.

3

IN CELL E

3

, NOT E2, FOLLOW THE SAME PROCEDURE, BRINGING THE FORMULA DOWN AS FAR AS YOU DID IN COLUMN "D". As you have not entered any numbers in yet, columns D and E should have numerous zeros listed.

4

SAVE THIS SPREADSHEET AS "GROCERY_MASTER" OR ANY OTHER NAME.

5

OPEN ANYTIME YOU NEED IT, BUT GIVE EACH NEW LIST A UNIQUE NAME TO PROTECT YOUR ORIGINAL TEMPLATE.
TIPS
This works for other spreadsheet programs, such as OpenOffice.org Calc.
WARNINGS
Always test new programs, such as spreadsheet programs, to ensure they work properly.
This program does not compute sales tax. Sales tax is determined differently depending on where you live.
THINGS YOU\'LL NEED
Spreadsheet program, such as Microsoft Excel