Insert A Calendar Drop Down In Excel. To do this, enter the dates into a column in. 370k views 4 years ago.
In the control tab, enter a cell reference in the cell link field. Click “open in desktop app”.
This Cell Will Store The Selected Date Value.
Create a list of dates.
After Setting Up The Data Validation For The Cell, A Drop Down Arrow Will Appear In The Cell.
Thanks to this function you’ll be able to use a date picker,.
In The Control Tab, Enter A Cell Reference In The Cell Link Field.
Images References :
I Added The Date Picker Calander On The Excel Sheet In The Top Row Of The Table And Freezed The Top Row, So Users Can Easily View The Calander Then Select The Cell.
To do this, navigate to the developer tab, click on insert in the controls group, and then select the date picker control.
Click On This Arrow To Open The Drop Down Calendar.