{"id":4380,"date":"2022-06-10T00:02:00","date_gmt":"2022-06-10T04:02:00","guid":{"rendered":"https:\/\/exceltheatre.com\/blog\/?p=4380"},"modified":"2022-05-28T14:56:16","modified_gmt":"2022-05-28T18:56:16","slug":"make-your-shopping-lists-in-excel","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2022\/06\/10\/make-your-shopping-lists-in-excel\/","title":{"rendered":"Make Your Shopping Lists in Excel"},"content":{"rendered":"<p>If you use Excel at work all day, do you keep using it when you get home? Excel is a great tool for making lists \u2013 with or without formulas!<\/p>\n<p><!--more--><\/p>\n<h3>Excel Shopping Lists<\/h3>\n<p>Of course you make your shopping lists in Excel, right?&nbsp; Or have you found a better system?<\/p>\n<p><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/05\/shoppinglistexcel01.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"shoppinglistexcel01\" style=\"border: 0px currentcolor; border-image: none; display: inline; background-image: none;\" alt=\"shoppinglistexcel01\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/05\/shoppinglistexcel01_thumb.jpg\" width=\"400\" height=\"400\" border=\"0\"><\/a><\/p>\n<h3>Weekly Meal Planner &amp; Shopping List<\/h3>\n<p>If you don&#8217;t already have a shopping list set up in Excel, try the list maker in free <a href=\"https:\/\/www.contextures.com\/excel-weekly-meal-planner.html\" target=\"_blank\" rel=\"noopener\">my Excel Weekly Meal Planner<\/a>.<\/p>\n<p>Just enter your favourite meals and their main ingredients, or search for new recipes.<\/p>\n<p>Then, click button to create weekly shopping list<\/p>\n<p>Watch this short video, to see how it works.<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/arwfkPSb6y8?rel=0\" allowfullscreen=\"\" allow=\"autoplay; encrypted-media\" loading=\"lazy\" width=\"450\" height=\"283\" frameborder=\"0\"><\/iframe><\/p>\n<h3>Choose Your Meals<\/h3>\n<p>There&#8217;s a weekly planning sheet in the Excel file, where you can select items for each weekday&#8217;s meals, by using the <a href=\"https:\/\/www.contextures.com\/xldataval01.html\">data validation drop down<\/a> lists.<\/p>\n<p><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/05\/excelmealplanner01.png\"><img loading=\"lazy\" decoding=\"async\" title=\"excelmealplanner01\" style=\"border: 0px currentcolor; border-image: none; display: inline; background-image: none;\" alt=\"excelmealplanner01\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/05\/excelmealplanner01_thumb.png\" width=\"380\" height=\"240\" border=\"0\"><\/a><\/p>\n<h3>Print Your Shopping List<\/h3>\n<p>Then, after all your meals are selected, click a worksheet button, to create your shopping list!<\/p>\n<p>In the shopping list, the items are summarized by category, in an <b><a href=\"https:\/\/www.contextures.com\/createpivottable.html\">Excel Pivot Table.<\/a><\/b><\/p>\n<p>With this list, you can head to the Frozen Food section, or the bakery, and get exactly what you need.<\/p>\n<p>For special occasions, see my <strong><a href=\"https:\/\/www.contextures.com\/Excel-Dinner-Planner.html\">Excel holiday dinner planner<\/a><\/strong>.<\/p>\n<p><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/05\/mealplanner05.png\"><img loading=\"lazy\" decoding=\"async\" title=\"mealplanner05\" style=\"border: 0px currentcolor; border-image: none; display: inline; background-image: none;\" alt=\"mealplanner05\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/05\/mealplanner05_thumb.png\" width=\"401\" height=\"252\" border=\"0\"><\/a><\/p>\n<p>____________________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you use Excel at work all day, do you keep using it when you get home? Excel is a great tool for making lists \u2013 with or without formulas!<\/p>\n","protected":false},"author":2,"featured_media":4374,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[23],"tags":[],"class_list":["post-4380","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tips"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4380","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=4380"}],"version-history":[{"count":2,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4380\/revisions"}],"predecessor-version":[{"id":4388,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4380\/revisions\/4388"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media\/4374"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=4380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=4380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=4380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}