How to Remove the Calendar Prompt When Entering Dates in Excel
Question details
The user wants to stop a small calendar prompt (date picker) from appearing when trying to type dates into spreadsheet cells.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering quick dates into a column (e.g., typing "8-8") and expecting them to automatically format as dates without interacting with a pop-up.
- Observed behavior
- A calendar prompt automatically appears, overriding the standard typing and auto-formatting behavior previously experienced by the user.
Before making changes, check if the calendar prompt appears in all your workbooks or just a specific file. This helps determine if the issue is document-specific, like a Data Validation rule, or application-wide, like an Add-in or recent update.
Clear Date Data Validation Rules
Use this solution if the calendar prompt only appears when you select specific columns or cells, which usually indicates an active data validation rule.
In many cases, workbooks downloaded from others or older templates have data validation applied. Some versions of Excel or active plugins will automatically display a date picker if the cell is strictly restricted to date inputs.
Highlight the specific column or range of cells where the calendar pop-up appears when you click on them.
Navigate to the 'Data' tab on the top ribbon, and click on 'Data Validation' in the Data Tools group.
In the Data Validation dialog box, click the 'Clear All' button at the bottom left, then click 'OK' to remove the restriction and disable the prompt.

Disable Third-Party Date Picker Add-ins
If the calendar prompt appears across all your Excel workbooks, a recently installed or updated Add-in is likely overriding the default behavior.
Manage Office Updates and Submit Feedback
If you recently updated Microsoft Office, the native date picker might be a new built-in feature introduced by Microsoft.
Enter and Format Dates Distraction-Free in WPS Office
If recent Excel updates have introduced unwanted pop-ups that slow down your workflow, consider using WPS Spreadsheet. It offers a distraction-free environment where shorthand date entries like '8-8' are automatically recognized and formatted, requiring zero extra clicks.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx workbook directly.
- 2. Type your date normally: Select any cell and type your date shorthand, such as '8-8', then press Enter.
- 3. Customize cell formatting: Right-click the cell, select 'Format Cells', and easily pick your preferred standard Date format without dealing with forced interface prompts.

Frequently Asked Questions
Why did a calendar prompt suddenly start appearing in my Excel?
This usually happens due to a recent Microsoft Office update that introduces a native date picker, the activation of a third-party calendar Add-in, or opening a workbook that has strict Date data validation rules applied to its cells.
Can I permanently disable the native Excel date picker?
If the date picker was introduced as a native feature in a recent Microsoft 365 update, there may not be a simple toggle to disable it in the Options menu. You can try rolling back your Office version or submitting feedback to Microsoft requesting a toggle switch.
How do I revert to typing '8-8' and having it auto-format to August 8th?
If the issue is caused by Data Validation or an Add-in, clearing the validation rules (Data > Data Validation > Clear All) or disabling the date-picker Add-in (File > Options > Add-ins) will immediately restore Excel's default auto-formatting behavior.
Does Data Validation always trigger a calendar pop-up?
Not natively in older versions of Excel. However, if you are using newer builds or have specific Add-ins installed, setting a cell's validation criteria strictly to 'Date' will trigger the calendar GUI to ensure the user inputs a valid date format.




