How to create a meal planner template in Excel

Feb 05, 2020 • edited Feb 06, 2020

How to create a meal planner template in Excel

Meal Planner

Planning your meals in advance is a wonderful way of sticking to healthy choices for your breakfast.With Excel meal planner, you can be sure to eat healthy and on time.

This article shows you how to create a meal planner in Excel. Here's what we are trying to achieve:

1. On the second sheet, create the following named ranges.

NameRange Address

Note: you can add 7 more breakfast meals in the future without changing the range address.

2. On the first sheet, select cell C4.

3. On the Data tab, in the Data Tools group, click Data Validation.

The ‘Data Validation’ dialog box appears.

4. In the Allow box, click List.

5. Click in the Source box and type =Breakfast.

6. Click OK.


7. Repeat steps 2 to 6 for cell D4 and cell E4, but instead of the Breakfast reference use the Lunch and Dinner reference.

8. Select the range C4:E4 and drag it down to row 10. This will copy the drop-down lists to the other days.


#How To#Tutorial#Meal Planner#Templates

How to create a simple invoice template in Excel

how to create a budget Template in Excel