Meal Planner in Excel

This article will talk about how to create a meal planner in Excel.

Here is what we want to achieve:

1. Add a second sheet and create the following named ranges in it.
   

   Range Name	Address range
   Breakfast	A2: A10
   Lunch	V2:V10
   Dinner	S2:S10

   

Note: You can add 7 more dishes to a column Breakfast without having to change the range address.

2. Highlight a cell C4 on the first sheet.
3. On the Advanced tab DATE (Data) click command Data Validation (Data validation).A dialog box will appear Data Validation (Checking input values).
4. From drop down menu Allow (data type) select List (List).
5. Place the cursor on the line Source (Source) and type “=Breakfast”.
6. Press OK.

Result:

7. Repeat steps 2 to 6 for cells D4 и E4, but instead of the name Breakfast use Lunch и Dinner.
8. Highlight a range C4:E4 and drag it down to the line 10. This will copy the dropdown lists to other days.

Result: