How to Enter a Fixed Date When Adding a New Excel Table Row
Question details
The user needs to insert a static date into a new table row that does not automatically update when the worksheet recalculates.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Adding a new row to an existing data table and recording the current date of entry.
- Observed behavior
- Using formulas like TODAY() or NOW() results in dates that constantly update when the workbook recalculates, rather than preserving the original entry date as a fixed value.
Ensure the target cell is formatted as a Date format (e.g., Short Date or Long Date) so the inserted value displays correctly.
Use the Keyboard Shortcut for Fixed Dates
The fastest and most reliable way to insert a static current date is by using Excel's built-in keyboard shortcut.
Click on the specific cell in the new table row where you want the fixed date to appear.
Press Ctrl + ; (the Control key and the semicolon key together) on your keyboard. The current date will be inserted immediately.
Press the Enter key to confirm the input. This date is now saved as a permanent value and will not change upon recalculation.

Set Workbook Calculation to Manual (Alternative)
You can temporarily stop TODAY() and NOW() formulas from updating by changing the workbook calculation mode to Manual.
Easily Manage Static and Dynamic Dates with WPS Spreadsheet
WPS Office provides an intuitive spreadsheet tool that fully supports Excel shortcuts, formulas, and table formatting. You can quickly insert fixed dates or manage complex calculations seamlessly without worrying about format issues.
- 1. Open your document in WPS: Launch WPS Spreadsheet and open your existing data table.
- 2. Select the target cell: Click the empty cell in your newly added row where the date is required.
- 3. Insert the static date: Press Ctrl + ; to instantly add the fixed current date, then press Enter.

Frequently Asked Questions
Why does my date change every time I open the spreadsheet?
If you used the TODAY() or NOW() function, Excel treats it as a volatile formula. It automatically recalculates the current system date and time whenever the file is opened or edited. To fix this, use the Ctrl + ; shortcut instead of a formula.
Can I automatically insert a fixed date when another cell in the row is populated?
To do this automatically without manual entry, you would need to use VBA (Visual Basic for Applications) to create a macro event, or enable iterative calculation to create a circular reference timestamp. Standard Excel formulas are inherently dynamic.
How do I insert both a fixed date and a fixed time in the exact same cell?
Select the cell, press Ctrl + ; to insert the date, press the Spacebar to add a single space, and then press Ctrl + Shift + ; to insert the current time. Press Enter to confirm the combined value.




