How to Prepare a Grocery List on Your Laptop Computer

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. Image titled Prepare a Grocery List on Your Laptop Computer Step 1
    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. 2
    Format columns B, D, and E for two decimal places in currency.

    • In cell D2, enter the formula " =B2*C2 "
      Image titled Prepare a Grocery List on Your Laptop Computer Step 2Bullet1
    • In cell E2, enter the formula = D2
      Image titled Prepare a Grocery List on Your Laptop Computer Step 2Bullet2
    • In cell E3, enter the formula = E2 + D3
      Image titled Prepare a Grocery List on Your Laptop Computer Step 2Bullet3
    • 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.
      Image titled Prepare a Grocery List on Your Laptop Computer Step 2Bullet4
  3. Image titled Prepare a Grocery List on Your Laptop Computer Step 3
    3
    In cell E3, 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. Image titled Prepare a Grocery List on Your Laptop Computer Step 4
    4
    Save this spreadsheet as "Grocery_Master" or any other name.
  5. Image titled Prepare a Grocery List on Your Laptop Computer Step 5
    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

Article Info

Categories: Spreadsheets | Meal Planning