Office Settings & Configuration

How to Remove the Calendar Prompt When Entering Dates in Excel

Nimra MalikNimra Malik Oct 14, 2026 873 views

Question details

The user wants to stop a small calendar prompt (date picker) from appearing when trying to type dates into spreadsheet cells.

How to Remove the Calendar Prompt When Entering Dates in Excel
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 you start

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.

Solution 1Recommended

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.

1
Select the affected cells

Highlight the specific column or range of cells where the calendar pop-up appears when you click on them.

2
Open Data Validation

Navigate to the 'Data' tab on the top ribbon, and click on 'Data Validation' in the Data Tools group.

3
Clear the rules

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.

Clear Date Data Validation Rules
Validation Cleared: You should now be able to type quick entries like '8-8' and have them automatically formatted to standard dates without the pop-up.

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx workbook directly.
  2. 2. Type your date normally: Select any cell and type your date shorthand, such as '8-8', then press Enter.
  3. 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.
Type shorthand dates naturally without forced calendar pop-upsFully compatible with Microsoft Excel (.xlsx) file formatsLightweight application with no intrusive background feature changes100% free to use with a familiar, easy-to-navigate interface
microsoft office alternative - wps office

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.