Install In-Cell Date Picker Calendar in Excel - Calendar Drop-down in Column

Install In-Cell Date Picker Calendar in Excel - Calendar Drop-down in Column - Excel 365, 2016, 2013

Рет қаралды 150,497

Күн бұрын

Download the feature file here www.bluepecantraining.com/ins...
In this video I demonstrate how to add a date picker functionality to Excel. I look at two methods, both of which work in the 64 bit and 32 bit version of Excel.
The first method uses Sam Radakovitz's date picker add-in which is compatible with all versions of Excel. Sam is a Microsoft employee and lead on Excel. samradapps.com/datepicker
The second method uses the Mini Calendar and Date Picker by Vertex 42 which is found in the Microsoft store
Both add-ins are free to use.
This video will answer the following queries:
How do I add a calendar to an Excel cell?
How do I add a calendar to an Excel sheet?
How do I add a calendar to an Excel drop down?
How do I add a datepicker calendar to cells in MS Excel?
How do I insert a drop down calendar?
How do I add an Excel date picker for entire column?
How do I add a date picker for Excel 365?
How do I add a date picker for Excel 2019?
How do I add a date picker for Excel 2016?
How do I add a date picker for Excel 2010?
How do I add a date picker for Excel 2007?
How do I install date add-ins?
How do I add date popup window?
How do I install date picker on worksheet?
How do I add a date picker for Excel 64 bit?
------------------------

Пікірлер: 67

@sarkartahseen 2 жыл бұрын

that was amazing, I liked it so much, you saved 30 Sec of my time every day which is equal to about 3.04 hours yearly, thank you

@lilfudgedragon1975 2 жыл бұрын

Thank you SO much for this video!!! It took me awhile to figure it out and I had to have my IT extract the file (Admin rights and all) but it worked like a charm once we got it!!! Thanks again!

@chrisamicucci7567 2 жыл бұрын

So easy to set up and works great! Thank you!

@7blackbarbie Жыл бұрын

Thank you very much! This was the most helpful I'd gotten. Easiest to follow!

@billykruger8392 2 жыл бұрын

This is fantastic. Thank you for this awesome tip.

@norlailabintimansorkpm-gur2071 3 жыл бұрын

THANK you. Very helpful and clear explanation.

@IvanCortinas_ES 3 жыл бұрын

I installed it months ago. It is very useful. Thank you very much for the information.

@ChesterTugwell 3 жыл бұрын

It's pretty cool!

@mariabodero7624 Жыл бұрын

This is awesome, took me so long to find a solution like this. Thank you so much

@EWBenham 2 жыл бұрын

Thanks! It worked like a dream. Can't wait to see what my teammates say about it!

@amitsams9760 2 жыл бұрын

Thank you so much for a simpler method.

@Kenneth45 2 жыл бұрын

Sam's method is awesome, thanks!

@SEKYEREISAAC-rz8bx Жыл бұрын

You are superb this is really helpful, you just solve my problem. God bless you. keep it up

@sixtyfiveroses2968 2 жыл бұрын

Awesome!! Thank you so much for this.

@r.a7783 8 ай бұрын

thank you so much for that updating instructors for this smart app.

@ahmadaltayeb1983 2 жыл бұрын

It is wonderful and helpfully, many thanks Sir.

@BaratonaMuraPa 2 жыл бұрын

Very Helpful. Thanks.

@tullioniccoli966 2 жыл бұрын

Thank so much Chester. Fantastic.

@chrisryley645 2 жыл бұрын

Does either of these controls require being installed by all users, or is inclusion in a shared spreadsheet sufficient to allow other users to use the control. Thanks

@lharamadlangbayan4425 2 жыл бұрын

Thank you so much! It was really a great help!

@fahmiffauzi9683 2 жыл бұрын

thanks .. very helpful

@lucasll2198 2 жыл бұрын

Really nice. There is any way that when you click the cell ( and it is still empty)the grid popup at the side?

@HugeNugeAdventures Жыл бұрын

This worked great. although even after changing the security settings i dont have the calendar on my ribbon?? any idea why?

@user-xg9yb7eb3b 9 ай бұрын

It was amazing, Thank you so much!

@thefrenchride 2 жыл бұрын

Thank you Chester! On Sam's method, how can I leave a blank cell but still see the tiny calendar next to the cell? Looks like at 4:43 you're able to do that. Thank you very much in advance!

@kent083089 Жыл бұрын

So glad I saw your video upon searching in Google :) Im an instant subscriber. Thank you! Thank you and more power!

@MrDhunpagla 3 жыл бұрын

Handy 😎👍 Thanks Mr T

@damienjacquemin195 2 жыл бұрын

Thank you for the tip!

@vipyoo6511 3 жыл бұрын

Hi, thank you for all your videos. They are very helpful. If I sent this spreadsheet to share with my teams will the calendar still show up for them or just me since they do not have this installed on their computer? Thank you!

@jeancarlosvargascruz1675 2 жыл бұрын

I was wondering the same thing. Did you find out?

@vancityexe 2 жыл бұрын

I tested this. If the extension ain't installed on the computer it's sent to, it won't work.

@Briefly21 10 күн бұрын

Thank you for your great instructional video. I have tried the install with no success. Is it correct to assume that this will not work for Mac Excel? As a Macbook user, can you point me to any resources that might help?

@ranikhazem8657 2 жыл бұрын

Thank you. 👍 Appreciated.

@YoussefBahlawi Жыл бұрын

thanks a lot. It is really a great job! .. So appreciate dear

@vicenteb1691 Жыл бұрын

Awesome. Thank You.

@skylarsky3173 11 ай бұрын

Thank you so much!!!

@chadmacpherson2401 Жыл бұрын

QQ - The first date picker is great, however, with a second monitor the date picker dialogue box remains on the primary screen. Any solutions for this by chance?

@larseskildsen5450 2 жыл бұрын

There is a minor issue with the weekdays when using Sam´'s calendar. February 22 is a Monday, but at the bottom of the calendar, February 22 is indicated as a Tuesday?

@nigelgreening3666 2 жыл бұрын

Is there a way to use this or another Date Picker function on Excel 365 (Online)?

@AlwaysHopeful87 3 жыл бұрын

Thank you.

@anassaboulghit1224 Жыл бұрын

worked, thanks

@sureshkumarreddyp1621 2 жыл бұрын

thank you so much

@nikhilck629 2 жыл бұрын

Why won’t Microsoft preinstall this?

@yinthuaung9838 2 жыл бұрын

Thanks Dear sir

@dpr4820 2 жыл бұрын

This is great. Thank you. Can you change the date format? For instance, I'd like it to be MM/DD/YY versus DD/MM/YY. Thanks!

@dpr4820 2 жыл бұрын

Disregard. It added it in the desired format. Maybe that has something to do with my computer setup. Thanks again. I love the tiny calendar next to the cells. :)

@isuruthiwanka9448 2 жыл бұрын

Thanks dude

@billottey8296 9 ай бұрын

inadvertently downloaded to mac, now can't uninstall, any suggestions on how to delete/uninstall datepicker? Thank you.

@gurmanjitkaur8864 2 жыл бұрын

Can we change placement of the Calendar Icon?

@qirouyang8215 9 ай бұрын

Hey! I'm using a mac and I tried to install this but it doesn't work. I wonder if there's a version for mac's excel?

@RachelPun 2 жыл бұрын

Why does my datepicker look old-fashioned and I get this "File not found: user32" message?

@CJ-gy8ie Жыл бұрын

I can't get either option to work for me. I have no clue how to add Sam's thing and my Excel won't load the 'Store'. Any other options?

@user-xj3wo3jn1q Жыл бұрын

Thank You!

@ChesterTugwell Жыл бұрын

You're welcome!

@koala3054 Жыл бұрын

Will this work on a MacBook Air?

@andrewdowdle4035 Жыл бұрын

Great feature, but how do you permanetly remove the date picker from a cell if you have accidently put it in the wrong cell? Deleting the row etc doesn't fix the problem

@zakwan4224 Жыл бұрын

Thanks

@janvernooij8921 3 жыл бұрын

How do i do this on a macbook?

@bobbarker142 Жыл бұрын

😂 don’t buy a mac

@leowouters1191 Жыл бұрын

does it works on MAC

@RealityShifter1 Жыл бұрын

Why Sam's date picker is not built directly into Excel now makes my brain hurt. Thanks for the video!

@amixel1 Жыл бұрын

this is not working in MS teams Excel :(

@CarlosLopez-sb1it 2 жыл бұрын

This is great too bad it didnt work on mac but it must be so cool for a PC I thought I got it to work but unfortunately the visual graphic didn't work for Sams Calendar. :/

@oilwings 3 жыл бұрын

This should be built into Excel. I can't get this to work because my company has the system locked down.

@clairemariviv 3 жыл бұрын

Same here

@mohammadaijaz4901 2 жыл бұрын

👍

@NewYears1978 4 ай бұрын

It's so stupid that this is not built into Excel. If you want to put this in a file that you distribute to other users, well it won't work unless they to install the add-ins and such. I really hate Microsoft.