Home

How to insert a Calendar in Excel 2013

%3CLINGO-SUB%20id%3D%22lingo-sub-659146%22%20slang%3D%22en-US%22%3EHow%20to%20insert%20a%20Calendar%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659146%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%20I%20wanna%20insert%20a%20drop-down%20calendar%20in%20my%20excel%20workbook%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20I%20have%20Win%2010%20Excel%202013%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-659146%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-659333%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20insert%20a%20Calendar%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659333%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F67342%22%20target%3D%22_blank%22%3E%40Antonio%20J%20Fabian%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20out%20this%20%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2016%2F10%2F12%2Finsert-calendar-excel-datepicker-template%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink.%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743350%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20insert%20a%20Calendar%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743350%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3EThank%20you%20for%20your%20reply%20to%20another%20user.%26nbsp%3B%20However%2C%20I%20don't%20have%20that%20listed.%26nbsp%3B%20I%20go%20to%20Developer%20%2F%20Insert%20%2F%20Active%20X%20controls%20%2F%20more%20controls%20%2F%26nbsp%3B%20and%20all%20I%20have%20is%20under%20the%20many%20Microsoft%20is%20Coolbar%20Controls%20going%20directly%20to%20DataGrid%20Control...%26nbsp%3B%20Any%20suggestions%3F%26nbsp%3B%20Lots%20of%20Microsoft%20items%20listed%20but%20none%20that%20look%20appropriate.%20(Microsoft%20365%20ProPlus)%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F67342%22%20target%3D%22_blank%22%3E%40Antonio%20J%20Fabian%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20out%20this%20%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2016%2F10%2F12%2Finsert-calendar-excel-datepicker-template%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink.%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743404%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20insert%20a%20Calendar%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743404%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372922%22%20target%3D%22_blank%22%3E%40sdinva7%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20scroll%20down%20the%20webpage%20I%20mentioned%20in%20the%20previous%20link%2C%20you%20will%20find%20this%20note%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122617iEC6534C1787C3D36%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%20Date%20Picker.png%22%20title%3D%22Excel%20Date%20Picker.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20built-in%20DateTime%20picker%20in%20Excel%20only%20exists%20in%20the%2032bit%20version%20of%20Excel.%3C%2FP%3E%3CP%3EIf%20you%20have%20the%2064bit%20version%20of%20Excel%2C%20you%20may%20try%20some%20third-party%20tools%20mentioned%20on%20the%20same%20page.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20good%20news%20is%20that%20the%20Excel%20team%20is%20currently%20working%20to%20add%20DateTime%20picker%20officially%20in%20all%20versions%20of%20Excel%20by%20this%20%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F13275054-add-date-picker-to-enable-users-to-select-a-date%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esource.%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EHaytham%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743406%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20insert%20a%20Calendar%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743406%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3EApologize%20for%20not%20reading%20the%20full%20article.%26nbsp%3B%20Thank%20you%20for%20your%20reply%3C%2FP%3E%3C%2FLINGO-BODY%3E
Antonio J Fabian
New Contributor

Hi Everyone I wanna insert a drop-down calendar in my excel workbook

Can someone help me I have Win 10 Excel 2013

4 Replies

@Antonio J Fabian 

 

Hi, 

 

Please check out this link.

 

Hope that helps

@Haytham AmairahThank you for your reply to another user.  However, I don't have that listed.  I go to Developer / Insert / Active X controls / more controls /  and all I have is under the many Microsoft is Coolbar Controls going directly to DataGrid Control...  Any suggestions?  Lots of Microsoft items listed but none that look appropriate. (Microsoft 365 ProPlus)


@Haytham Amairah wrote:

@Antonio J Fabian 

 

Hi, 

 

Please check out this link.

 

Hope that helps


 

@sdinva7

 

Hi,

 

If you scroll down the webpage I mentioned in the previous link, you will find this note:

 

Excel Date Picker.png

 

The built-in DateTime picker in Excel only exists in the 32bit version of Excel.

If you have the 64bit version of Excel, you may try some third-party tools mentioned on the same page.

 

The good news is that the Excel team is currently working to add DateTime picker officially in all versions of Excel by this source.

 

Regards,

Haytham

@Haytham AmairahApologize for not reading the full article.  Thank you for your reply

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies