This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello, I am obsessed with the weekly meal planner template; however, I would like to make the meal planner tab 15 days instead of the weekly 7 days. Unfortunately, I am unaware of how to edit the formatting to do so. I am able to copy the formula on the meal planning tab, but the information does not transfer onto the Shopping List tab: I believe this is the tab that needs to be updated. Suggestions? I have version 2108.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
All that you need to do is select cell B10 and the left click and hold on the bottom right of the outline of the cell and drag down as many rows as required. When you release the mouse button the required day names will be inserted into each of the cells.
Hello,
I tried looking for an expanded meal plan but one does not exist. I am using the "Weakly Meal Planner" template and am 100% sure that the formula on the Shopping List page needs to be updated.
I'm guessing you are using one of the free download MS templates.
Please give us the full name you use to search for it, or better yet the link to the description/download page you got it from.
As well as adjusting the daily part, you have to adjust the formulas on the shopping page part.
Actually, you could also try searching the web for other free templates you can download. ie search with "weekly meal planner with grocery list" or "biweekly meal planner with grocery list" or "2 week meal planner with grocery list" https://therealfooddietitians.com/healthy-meal-plan-2/ (this is just an example, not a specific suggestion)
It is quite a complex workbook with a number of hidden worksheets (Ingredient Master List, Measurement Master List, and Data Analysis) and extending the full functionality to accommodate a second week would be a major undertaking.
It would probably be much easier to create a second workbook for the second week and then use some VBA code to combine the required sheets from the workbook for each week into a third workbook.
Hello,
Unfortunately, that does not solve the problem. I have already done that part. There is another tab titled Shopping List. This tab adds the ingredients from the recipes added to the Meal Planner. The additional days added do not upload to the shopping list.