How to Create a Family Meal Plan in Excel
Open Microsoft Excel., Plan., Select a blank WorkBook., Label., Color in columns and rows, if desired., Decide what you are going to eat., Expand the Cell Width in case the text are too long to display., Complete the meal plan., Align the header in...
Step-by-Step Guide
-
Step 1: Open Microsoft Excel.
The icon is green. -
Step 2: Select a blank WorkBook.
Decide how you want to categorize the chart.
This depends on how many meals there are and how much time you want the plan to cover.
For this demonstration, we will create a three day plan for a family that eats together for breakfast, lunch, and dinner. , If you are using Microsoft Office Excel 2013, the start page will ask you if you want to create a blank WorkBook or use a template. , Across the top of the chart, label the meals.
Down the sides, label the days that you will be doing the plan. , It may help you to color in the parts of the chart that are headings so that it doesn't get confusing and cluttered.
Select a column or row by clicking the letter or number that it corresponds with.
Click the paint can near the top of the screen.
It is under the font selector.
The default color is yellow, but you can change it by clicking the downwards triangle to the right of the paint can. , A good way to do this is to have a family meeting.
Make sure you have your chart up and type down what you decide on.
To fill in the chart, click the cell that corresponds with the meal and day you have chosen and type.
Be as brief or as detailed as suits your needs.
You can use a basic label like "stew" or go into detail on ingredients and side dishes.
You can even find recipes online and copy the links to them into the chart, if desired. , Drag the line between the cells to adjust its width. , Input the days from Monday to Sunday and put the desired meal according to your preferences. ,,, Click on the button beside the Fill Color button and change it into what ever color your want. , Select Rows 2 to 8 , Click on the Fill Color button and change it into any color your want. ,, You can add grid lines or any other color depends on what you want. , You may want to change the plan from week to week, or even during the week to use up leftover ingredients, accommodate a change in daily routine/schedule, or adjust based on preferences or cravings.
When this happens, make sure you plan ahead of time, but don't be afraid to be flexible.
A meal plan shouldn't lock your family into a pattern that's set in stone. -
Step 3: Label.
-
Step 4: Color in columns and rows
-
Step 5: if desired.
-
Step 6: Decide what you are going to eat.
-
Step 7: Expand the Cell Width in case the text are too long to display.
-
Step 8: Complete the meal plan.
-
Step 9: Align the header in center to make it more visible by highlighting the top row then click the "Align to Center" button in the toolbar.
-
Step 10: Select the cell with the name of days from Monday to Sunday.
-
Step 11: Change its font color.
-
Step 12: Select the rows of the day.
-
Step 13: Change the background color.
-
Step 14: Select again the cell with the name of days from Monday to Sunday and change its color same as the color of the header column.
-
Step 15: Make the table more presentable.
-
Step 16: Change the plan as needed.
Detailed Guide
The icon is green.
Decide how you want to categorize the chart.
This depends on how many meals there are and how much time you want the plan to cover.
For this demonstration, we will create a three day plan for a family that eats together for breakfast, lunch, and dinner. , If you are using Microsoft Office Excel 2013, the start page will ask you if you want to create a blank WorkBook or use a template. , Across the top of the chart, label the meals.
Down the sides, label the days that you will be doing the plan. , It may help you to color in the parts of the chart that are headings so that it doesn't get confusing and cluttered.
Select a column or row by clicking the letter or number that it corresponds with.
Click the paint can near the top of the screen.
It is under the font selector.
The default color is yellow, but you can change it by clicking the downwards triangle to the right of the paint can. , A good way to do this is to have a family meeting.
Make sure you have your chart up and type down what you decide on.
To fill in the chart, click the cell that corresponds with the meal and day you have chosen and type.
Be as brief or as detailed as suits your needs.
You can use a basic label like "stew" or go into detail on ingredients and side dishes.
You can even find recipes online and copy the links to them into the chart, if desired. , Drag the line between the cells to adjust its width. , Input the days from Monday to Sunday and put the desired meal according to your preferences. ,,, Click on the button beside the Fill Color button and change it into what ever color your want. , Select Rows 2 to 8 , Click on the Fill Color button and change it into any color your want. ,, You can add grid lines or any other color depends on what you want. , You may want to change the plan from week to week, or even during the week to use up leftover ingredients, accommodate a change in daily routine/schedule, or adjust based on preferences or cravings.
When this happens, make sure you plan ahead of time, but don't be afraid to be flexible.
A meal plan shouldn't lock your family into a pattern that's set in stone.
About the Author
Frances Chavez
Writer and educator with a focus on practical lifestyle knowledge.
Rate This Guide
How helpful was this guide? Click to rate: