Скачать или смотреть Excel date picker: insert an excel date picker calendar in a cell

NOTE: This video is for the 32 bit version of excel - if you have the 64 bit version, try the second method below.
** UPDATE: check out our second video in this series - try it out if this method doesn't work for you!    • Excel date picker: insert an excel date pi...   **
*UPDATE 2: if the above methods don't work, have you considered using Google Sheets? Check out this video:    • Google Sheets Date Picker: The Best Excel ...  *

This beginners tutorial looks at one method of inserting a date picker in excel. Using the developer tab, we show you how to insert a drop down calendar in excel (office 365) and this calendar acts as a date chooser in excel. Also learn how to set a specific date range and link your excel calendar picker to a cell so that you can use the date in formulas.

You can follow along with this tutorial from a blank workbook! Learn this great tip to add a drop down box with a pop-up calendar.

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

Check out our other videos and playlists