Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to retrieve first match between two ranges in Excel
  • How to use Excel VLOOKUP Function
  • How to get address of last cell in range in Excel
  • How to use Excel ROWS Function
  • How to create dynamic named range with OFFSET in Excel

Data Analysis Examples

  • How to Use Solver Tool in Excel
  • How to count table columns in Excel
  • How to create Gauge Chart in Excel
  • How to Create Thermometer Chart in Excel
  • Number and Text Filters Examples in Excel

Data Validation Examples

  • Data validation must not exist in list
  • Excel Data validation exists in list
  • Excel Data validation date in specific year
  • Excel Data validation with conditional list
  • Excel Data validation whole percentage only

How to create a meal planner in Excel

by

Meal Planner helps plan meals for the week or more.

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.

Name Range Address
Breakfast A2:A10
Lunch B2:B10
Dinner C2:C10

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.

Result:

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.

Result:

Post navigation

Previous Post:

Conditional Formatting Icon Sets Examples in Excel

Next Post:

How to create your own Search Box in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Get first name from name with comma — Manipulating NAMES in Excel
  • How to Remove Leading Spaces in Excel
  • Extract word that begins with specific character in Excel
  • How to extract domain name from URL in Excel
  • PROPER function: Description, Usage, Syntax, Examples and Explanation
  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • Get day from date in Excel
  • Convert Excel time to decimal minutes
  • DAY function: Description, Usage, Syntax, Examples and Explanation
  • Add workdays no weekends in Excel
  • How to calculate present value of annuity in excel
  • NPER function: Description, Usage, Syntax, Examples and Explanation
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
  • PMT function: Description, Usage, Syntax, Examples and Explanation
  • Future value vs. Present value examples in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles