# How to Add a Date Picker Calendar to Cells in MS Excel

> To add a date picker calendar in Microsoft Excel, select your target cell, open the Number Format menu on the Home tab, and choose either Short Date or Long Date. Finally, double-click the selected cell to bring up the calendar.

Canonical: https://livedemo.ai/tutorials/how-to-add-a-date-picker-calendar-to-cells-in-ms-excel/
Apps: Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a0116243f01ed60a4ec32/preview?step=1

## Steps

1. Inside your Microsoft Excel worksheet, find and select the cell where you want to add the date picker calendar.
2. After that, go to the top menu bar and click the 'Number Format' menu under the Home tab.
3. Choose 'Short Date' or 'Long Date' from the list of options.
4. After completing these steps, the date picker calendar will be automatically added to the selected cell. Simply click the cell twice to bring out the date picker.