How to Create a Family Meal Plan in Excel

Making a meal plan for your family can help cut costs on food, as well as make sure everyone is happy with what they are eating. This article will help you plan a meal for your family using Microsoft Office Excel. Exact button layout may differ depending on your version of Excel, but the steps are similar in any edition of the program.
[[Category:Family Life]]
== Steps ==
=== Making the Plan ===
#Open Microsoft Excel. The icon is green.[[Image:Create a Family Meal Plan in Excel Step 1.jpg|center]]
#Plan. 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.[[Image:Create a Family Meal Plan in Excel Step 2.jpg|center]]
#* For this demonstration, we will create a three day plan for a family that eats together for breakfast, lunch, and dinner.
#Select a blank WorkBook. 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.[[Image:Create a Family Meal Plan in Excel Step 3.jpg|center]]
#Label. Across the top of the chart, label the meals. Down the sides, label the days that you will be doing the plan.[[Image:Create a Family Meal Plan in Excel Step 5.jpg|center]]
#Color in columns and rows, if desired. It may help you to color in the parts of the chart that are headings so that it doesn't get confusing and cluttered.[[Image:Create a Family Meal Plan in Excel Step 6.jpg|center]]
#* Select a column or row by clicking the letter or number that it corresponds with.[[Image:Create a Family Meal Plan in Excel Step 7.jpg|center]]
#*Click the paint can near the top of the screen. It is under the font selector.[[Image:Create a Family Meal Plan in Excel Step 8.jpg|center]]
#*The default color is yellow, but you can change it by clicking the downwards triangle to the right of the paint can.[[Image:Create a Family Meal Plan in Excel Step 9.jpg|center]]
#Decide what you are going to eat. 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.[[Image:Create a Family Meal Plan in Excel Step 10.jpg|center]]
#* 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.
#Expand the Cell Width in case the text are too long to display. Drag the line between the cells to adjust its width.[[Image:Create a Family Meal Plan in Excel Step 11.jpg|center]]
#Complete the meal plan. Input the days from Monday to Sunday and put the desired meal according to your preferences.[[Image:Create a Family Meal Plan in Excel Step 12.jpg|center]]
=== Customizing Your Design ===
# 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.[[Image:Create a Family Meal Plan in Excel Step 13.jpg|center]]
#Select the cell with the name of days from Monday to Sunday.[[Image:Create a Family Meal Plan in Excel Step 14.jpg|center]]
#Change its font color. Click on the button beside the Fill Color button and change it into what ever color your want.[[Image:Create a Family Meal Plan in Excel Step 15.jpg|center]]
#Select the rows of the day. Select Rows 2 to 8[[Image:Create a Family Meal Plan in Excel Step 16.jpg|center]]
#Change the background color. Click on the Fill Color button and change it into any color your want.[[Image:Create a Family Meal Plan in Excel Step 17.jpg|center]]
#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.[[Image:Create a Family Meal Plan in Excel Step 18.jpg|center]]
#Make the table more presentable. You can add grid lines or any other color depends on what you want.[[Image:Create a Family Meal Plan in Excel Step 19.jpg|center]]
#Change the plan as needed. 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.[[Image:Create a Family Meal Plan in Excel Step 20.jpg|center]]

== Tips ==
*If you have a menu item with a long name, such as "Roasted Chicken and Vegetables," and you want to prevent it from spilling over into other columns, hover your cursor over the top of the column you are in and a line with arrows on either side will appear. Click the left mouse button and drag to extend or shorten the length of the column.

== Related wikiHows ==
*[[Edit Data in Microsoft Excel]]
*[[Meal Plan]]
*[[Make a Family Budget]]

__PARTS__

Comments

Post a Comment

Popular posts from this blog

Enjoy a Screen‐Free Week with Your Family

Image
While a week without screens might feel daunting, it can be enjoyable for the whole family. When preparing to go screen-free for a week, have some activities lined up to look forward to. Spend more time outside and get the kids involved in daily activities. Try new things and explore your community. This type of special time with family will allow you all to have quality bonding time and a chance to learn more about each other, especially for your children. Embrace the opportunity to learn more about your children’s likes and dislikes. Quality time is also a way for each of you to give full attention to each other, sending the message that your family is the most important thing in your lives. For extra support, get other families involved and have the kids play together.  [[Category:Family Life]] == Steps == ===Preparing for the Week=== # Talk about the upcoming week. Let your children know ahead of time that the family will take a break from screens so that they can mental...
Read more

How to Avoid Being Overwhelmed by Information

Image
You are likely exposed to over 15 hours of media every single day, emanating for dozens of different sources of information conveyed via video, print, audio, and more.<ref>http://www.pewinternet.org/2014/12/08/more-information-yields-more-learning-and-sharing/</ref> It is becoming increasingly harder to prevent all of the this information to lead to a constant feeling of being overwhelmed.  Accordingly, it becomes increasingly important to take steps to limit the amount of information that is allowed access to your attention, keep your virtual and physical workspaces free of debris, and take care of yourself to keep information overload at bay. [[Category:Creating Life Balance]] == Steps == ===Limiting the Amount of Information You Encounter=== #Take a tech break. If you feel like you’re starting to drown in information, the best way to get your feet back on solid ground is by turning off the faucet.  Every single day, get away from both your phone and comp...
Read more

Become Less of a Control Freak

Image
Control can be very tempting, especially if your life is chaotic and stressful. However, trying to control every aspect of a situation often does more harm than good. If you find yourself becoming a control freak, work on altering your worldview. Communicate more directly with others and learn when to let things go. Look at things from another person's perspective, as this will help you remember you're not right about everything. With a little dedication, you can overcome control freak tendencies.  [[Category:Creating Life Balance]] == Steps == === Altering Your Worldview === #Admit you have issues with control. If you're controlling, you may have a tendency to assume you're right. Recognize when you feel your way is the only way to complete a task. Acknowledge that the problem is your need for control and not someone else's shortcomings.<ref>https://www.forbes.com/2010/10/11/control-freak-perfectionism-workplace-forbes-woman-leadership-boss.html</ref...
Read more