Excel NOW Shortcut: Insert the Current Date and Time

Excel has no dedicated keyboard shortcut that inserts the NOW() formula. To enter a fixed date and time, press Ctrl+;, then Space, then Ctrl+Shift+; on Windows. To display a date and time that updates when Excel recalculates, enter =NOW() in a cell.

What NOW Means in Excel

NOW() is a date-and-time function in Microsoft Excel for Microsoft 365 on Windows. It returns the current date and time according to the computer’s system clock. The parentheses are required, but the function takes no arguments. The result is a live formula result, not a permanent record of the moment you first typed it.

Excel stores dates and times as numbers: the whole-number portion represents a date, and the fractional portion represents the time of day. For example, a time is represented by a fraction of 24 hours. Excel formats that number so it appears as a readable date, time, or combination of both. If a cell shows an unexpected number after you enter the function, the formula may be working correctly but the cell may need a date-and-time format.

“NOW shortcut” can therefore mean two different things: a way to enter the current date and time as fixed text-like values, or a quick way to create a formula that updates. The distinction matters. The keyboard method inserts a fixed timestamp; the function creates a changing result.

Insert a Fixed Date and Time with a Shortcut

To put an unchanging date and time into the selected cell on Windows, use this sequence:

Press Ctrl+; to insert the current date.
Press Space to separate the date from the time.
Press Ctrl+Shift+; to insert the current time.

The result is a fixed value: it will not change when the workbook recalculates or is opened later. The date and time display depend on the cell’s number format and regional settings. For instance, the same date might appear as 11/2/2026 or 2/11/2026 in different locales. Excel inserts the date and time from the computer’s clock, so check that clock if the value is wrong.

On a Mac, the usual shortcuts are Control+; for the date and Command+; for the time. Insert the date, a space, and then the time to create a combined fixed timestamp. Keyboard layouts and Excel settings can affect how punctuation keys are entered, so if a shortcut does not work, check the Excel menu or keyboard-shortcut help for your setup.

These shortcuts are useful for logging when a task was completed, recording a receipt date, or adding a fixed entry to a form. They do not enter the NOW function. That difference is often the answer to why a timestamp stays unchanged even after the workbook is opened on another day.

Enter a Live NOW Formula

With the formula entered in cell A1, =NOW() returns the current date and time; the exact displayed value depends on the computer clock and A1’s number format. Type the formula into a cell and press Enter. You can also select a cell, type an equals sign and the function name, and accept Excel’s function suggestion if it appears.

Because the function is dynamic, its result can change when Excel recalculates the workbook. It does not normally tick forward like a digital clock, updating visibly every second. Instead, it recalculates as part of Excel’s calculation process, such as when a relevant recalculation occurs or when the workbook is opened. Pressing F9 recalculates formulas in open workbooks in desktop Excel for Windows; Shift+F9 recalculates the active worksheet.

To place a timestamp next to a particular row, enter =NOW() in that row’s timestamp cell. Be aware that this does not permanently record when the row was created: the formula may show a later time after recalculation. For a lasting record, use the fixed keyboard shortcut instead, or copy the formula result and paste it as a value.

Format the Date and Time So They Are Readable

If Excel displays a serial number rather than a recognizable date, select the cell and use Home > Number Format to choose a date, time, or custom format. You can also open the Format Cells dialog with Ctrl+1 on Windows, select the Number tab, and choose a suitable category. On a Mac, Command+1 opens Format Cells in many Excel versions.

For a combined display, choose a date-and-time option if one is available, or choose Custom and select a format that includes both date and time components. The formatting changes only how the value appears; it does not turn a fixed timestamp into a formula or make a formula permanent. If a column is too narrow, widen it before assuming the entry is incorrect. A string of number signs can indicate that the cell needs more width for its current format.

Formatting is especially useful when you want to compare entries. A display with date and time down to minutes may be enough for a daily checklist, while a seconds component can help distinguish events that happen close together. Excel still stores the underlying date-and-time number; the chosen format controls which parts are visible.

NOW Versus the Fixed Timestamp Shortcut

Choose based on whether you want a value to move forward with recalculation or stay as entered. A NOW formula is appropriate for a dashboard that should show the current time whenever it recalculates, or for a worksheet that calculates elapsed time from the present. A fixed timestamp is more appropriate for a completed-work log, because it preserves the moment you entered it.

Fixed shortcut: inserts a date and time value that remains unchanged. It is quick for manual data entry and does not depend on formula recalculation.
NOW() formula: returns a current date-and-time result that can change on recalculation. It is useful for live calculations and displays, but not as a permanent audit trail.
Formatting: controls the visible presentation of either kind of value. It does not control whether the value updates.

A common misconception is that using =NOW() records the exact time a cell was first filled in. It does not. If a workbook needs an enduring timestamp whenever someone changes a row, a plain NOW formula is not enough: it may recalculate later, and building a reliable automated entry process requires a different approach and careful testing.

Recalculation, Workbooks, and Excel for the Web

Excel normally uses automatic calculation, which recalculates formulas as needed. If calculation is set to manual, a NOW formula may appear not to update until you trigger calculation. In desktop Excel, check Formulas > Calculation Options and select Automatic if that is the intended behavior. Changing this setting can affect formula calculation throughout the workbook, not just the cell containing NOW.

Excel for the web supports common worksheet formulas, including NOW, but keyboard shortcuts can vary with the browser, operating system, and keyboard layout. If a shortcut is intercepted or does something unexpected, enter =NOW() in a cell for a live value, or use the ribbon and cell-format controls. When editing a shared workbook, remember that the formula uses the environment’s current date and time and is not a guaranteed, immutable record of who made a change.

For workbooks used on both Windows and Mac, formulas and stored date-time values generally travel with the workbook, while shortcut keys can differ. A user opening the file may also see a different date or time presentation because of their regional settings. Agreeing on a clear date format can prevent confusion, especially when a date such as 03/04 could mean March 4 or April 3.

Common Problems and Practical Fixes

The cell shows a number: apply a date-and-time number format. Excel stores date-time values numerically, so a general or number format may not look like a timestamp.
The time looks wrong: check the device’s clock, time zone, and regional settings. NOW reads the system’s current date and time; it is not a network time-verification service.
The value does not change: confirm that the cell contains =NOW(), not a fixed shortcut value, and check whether calculation is set to automatic. Recalculate the sheet if needed.
The value changes when you did not expect it: that is normal for NOW. Replace it with a fixed timestamp if the entry must remain stable.
The shortcut does not enter a semicolon: keyboard layouts can place punctuation on different keys, and laptop keyboards may require an additional modifier. Use the formula or Excel’s menus as a fallback.

One further caution: NOW reflects the computer’s local clock and may be affected by a clock that is set incorrectly. It does not add a separate time-zone label to the cell. For records that must be auditable or legally reliable, use an approved logging or database process rather than relying on a recalculating spreadsheet formula alone.

Frequently Asked Questions

What is the shortcut for NOW in Excel?
There is no dedicated shortcut that enters the NOW function. Type =NOW() for a dynamic result. To insert a fixed date and time on Windows, press Ctrl+;, Space, then Ctrl+Shift+;.

How do I insert only the current date?
On Windows, select a cell and press Ctrl+;. On a Mac, the usual shortcut is Control+;. The inserted date is fixed, not a formula that changes tomorrow.

How do I insert only the current time?
On Windows, press Ctrl+Shift+;. On a Mac, the usual shortcut is Command+;. Excel inserts a fixed time value; it does not keep counting.

Does NOW update every second?
No. NOW is recalculated as part of Excel’s calculation process; it is not designed as a continuously refreshing clock. Recalculate the workbook or worksheet to request an updated result.

How can I stop a NOW result from changing?
Copy the cell and paste its result as a value, or enter the date and time using the fixed-value shortcuts. Once the formula has been replaced by a value, later recalculation will not change that timestamp.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.