Forum Discussion
Calendar Pop-up after double clicking on Cell
Microsoft lacks the basic features or I'm not smart enough to discover features like this
In Excel for the web, so far i know, there is no built-in feature to display a calendar pop-up when double-clicking on a cell.
As far as I have seen in the Microsoft Store, there are AddIns for it.
Here is an example from the store, untested.
MS Online Store
VERTEX42
Get started with the add-in:
Open in Excel OnlineThis add-in works in: Excel 2016 or later on Mac, Excel on the web, Excel 2013 Service Pack 1 or later on Windows.
As an alternative approach, you could use data validation and a drop-down list of dates.
- Select the cell or range of cells where you want to have the calendar pop-up.
- Click on the "Data" tab in the Excel ribbon.
- Click on the "Data Validation" button in the Data Tools group.
- In the Data Validation dialog box, select the "List" option from the "Allow" drop-down menu.
- In the "Source" field, enter the dates you want to include in the drop-down list, separated by commas. For example, you can enter a range of dates like "01/01/2023, 01/02/2023, 01/03/2023" and so on.
- Check the box next to "In-cell dropdown" to enable the drop-down list.
- Click "Save" to apply the data validation.
Now, when you double-click on the cell, a drop-down list will appear with the dates you specified. While it's not exactly a calendar pop-up, it provides a convenient way to select dates within Excel for the web. The steps were processed using AI.
Hope this information will be of help to you.
- I appreciate your response, but that's a lot of steps to choose a date as compared with google sheets. I think, I will enter manually until the Intelligent Microsoft Developers Team add this basic feature.
- Is the add-in not suitable for your project?
