Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

How to Create Drop-down Calendar in Excel?

In this post, you’ll learn about the drop-down calendar in excel and how to use it to display a date time picker in your Excel Worksheet.

What is Drop-Down Calendar?

A drop-down calendar in Excel is technically called Microsoft Date and Time Picker Control.

How to Create Drop-down Calendar in Excel?

Follow the below steps to add drop-down calendar in your excel workbook.

  • First, prepare a excel sheet with the required details in it.
How to create drop-down calendar in Excel?
  • To create a drop-down, select the cells.
  • Go to data tab > data validation.
How to create drop-down calendar in Excel?
  • A data validation dialog box opens up, select setting > then in allow just select the value that you want to be validated > data.
How to create drop-down calendar in Excel?
  • Now go to Input Message > enter the Title > enter the message.
How to create drop-down calendar in Excel?
  • As the final step go to Error Alert > choose the Style > enter the Title > enter the Error message > Ok.
How to create drop-down calendar in Excel?
  • Now enter the dates and check the error message by giving the date that exceeds the given limit.
  • You can see an error message.
How to create drop-down calendar in Excel?
  • The below image is the result for the steps above.
How to create drop-down calendar in Excel?