How to Prepare a Grocery List on Your Laptop Computer

Step-by-Step Guide

1. 1

   Step 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

   Step 2: Format columns B

   In cell D2, enter the formula " =B2*C2 " 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. , As you have not entered any numbers in yet, columns D and E should have numerous zeros listed. ,,
3. 3

   Step 3: and E for two decimal places in currency.

4. 4

   Step 4: In cell E3

5. 5

   Step 5: NOT E2

6. 6

   Step 6: follow the same procedure

7. 7

   Step 7: bringing the formula down as far as you did in column "D".

8. 8

   Step 8: Save this spreadsheet as "Grocery_Master" or any other name.

9. 9

   Step 9: Open anytime you need it

10. 10

    Step 10: but give each new list a unique name to protect your original template.

Detailed Guide

About the Author