Calendar Pop-up after double clicking on Cell

Copper Contributor

Microsoft lacks the basic features or I'm not smart enough to discover features like this

sumit809_0-1687156165281.png

 

9 Replies

@sumit809 

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

Mini Calendar and Date Picker

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.

  1. Select the cell or range of cells where you want to have the calendar pop-up.
  2. Click on the "Data" tab in the Excel ribbon.
  3. Click on the "Data Validation" button in the Data Tools group.
  4. In the Data Validation dialog box, select the "List" option from the "Allow" drop-down menu.
  5. 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.
  6. Check the box next to "In-cell dropdown" to enable the drop-down list.
  7. 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?
Nope. Why would anyone want that calendar hanging in my spreadsheet?😅
It should be an Integrated feature in excel. The cell is already formatted as date, so why not pup-up date picker when I double click? Wouldn't it be best?
Because excel for web is free, if all options were available in excel for web, what's the point of buying a subscription?

@NikolinoDE 

But you can also give feedback for improvement.

How do I give feedback?

Microsoft Feedback portal

 

I wish you continued success with Excel!

Because I'm already paying $1.5/month😅
Paying for Excel for web??
You probably mean additional storage for OneDrive.
Sorry for the confusion. I work in an Organisation and I have the Microsoft standard license ($1.5/month per user) which doesn't allow editing on the Excel Application for MacOS. So I use Excel for Web (Because earlier I liked to use googlesheets which is web-only) So, I was expecting the same features.