Calculation Issues

How to Enter a Fixed Date When Adding a New Excel Table Row

Emma BrownEmma Brown Oct 21, 2026 872 views

Question details

The user needs to insert a static date into a new table row that does not automatically update when the worksheet recalculates.

How to Enter a Fixed Date When Adding a New Excel Table Row
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.
Before you start

Ensure the target cell is formatted as a Date format (e.g., Short Date or Long Date) so the inserted value displays correctly.

Solution 1Recommended

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.

1
Select the target cell

Click on the specific cell in the new table row where you want the fixed date to appear.

2
Press the date shortcut

Press Ctrl + ; (the Control key and the semicolon key together) on your keyboard. The current date will be inserted immediately.

3
Confirm the entry

Press the Enter key to confirm the input. This date is now saved as a permanent value and will not change upon recalculation.

Use the Keyboard Shortcut for Fixed Dates
Add Current Time: To add the current time as a fixed value alongside your date, select another cell and press Ctrl + Shift + ;.
Efficient Spreadsheet Management

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. 1. Open your document in WPS: Launch WPS Spreadsheet and open your existing data table.
  2. 2. Select the target cell: Click the empty cell in your newly added row where the date is required.
  3. 3. Insert the static date: Press Ctrl + ; to instantly add the fixed current date, then press Enter.
Fully compatible with Microsoft Excel (.xlsx) formats and standard keyboard shortcuts.Easily input fixed dates using standard shortcuts like Ctrl + ; without formulas.Free and lightweight suite perfect for everyday data entry and tracking.
microsoft office alternative - wps office

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.