You need to quickly add the current date or time into an Excel cell without typing it manually. Excel provides two dedicated keyboard shortcuts for this exact purpose. These shortcuts insert static values that do not update automatically. This article explains how to use Ctrl+; for the date and Ctrl+Shift+; for the time.
Key Takeaways: Insert Static Date and Time
- Ctrl+; (Semicolon): Inserts today’s date as a static value in the active cell.
- Ctrl+Shift+; (Semicolon): Inserts the current time as a static value in the active cell.
- Ctrl+; then Space then Ctrl+Shift+;: Inserts both the static date and time into the same cell.
How the Date and Time Shortcuts Work
The Ctrl+; and Ctrl+Shift+; shortcuts are designed for data entry speed. They place a fixed timestamp into your worksheet. This value is like any other number you type. It will not change when you open the file tomorrow or recalculate formulas.
Excel stores dates and times as serial numbers. A date is the number of days since January 0, 1900. A time is a decimal fraction of a day. The shortcuts enter these numbers with a date or time format applied. You can change this format later without affecting the underlying value.
Static vs Dynamic Date and Time
It is important to know the difference between static and dynamic entries. The shortcuts create static entries. For a dynamic timestamp that updates, you would use the TODAY or NOW functions. Use the shortcuts when you need a permanent record, like an invoice date or a log entry time.
Steps to Insert Date and Time with Keyboard Shortcuts
Follow these steps to use the shortcuts correctly. Ensure Num Lock is off if you are using a keyboard with a number pad.
- Select the target cell
Click on the cell where you want the date or time to appear. - Insert today’s date
Press and hold the Ctrl key, then press the semicolon (;) key. Release both keys. Excel enters the current date. - Insert the current time
Press and hold Ctrl and Shift simultaneously, then press the semicolon (;) key. Release all keys. Excel enters the current time. - Insert both date and time in one cell
First, press Ctrl+; to insert the date. Then, press the Spacebar once. Finally, press Ctrl+Shift+; to add the time. The cell will now show both values.
Using the Shortcuts in Multiple Cells
You can insert the same timestamp into several cells at once.
- Select a range of cells
Click and drag to highlight all the cells you want to fill. - Use the shortcut
Press Ctrl+; or Ctrl+Shift+;. Excel places the date or time into every selected cell. - Confirm the entry
Press Ctrl+Enter to finalize the entry in all cells without moving the selection.
Common Mistakes and Limitations
Shortcut Does Not Work or Inserts Wrong Character
If the shortcut types a different character, your keyboard layout may use a different key for the semicolon. On some international keyboards, you press Shift+Comma to get a semicolon. In this case, try Ctrl+Shift+, (comma) for the date. Test which key produces a semicolon in Notepad first.
Date or Time Does Not Update Automatically
This is the expected behavior for these shortcuts. They insert a fixed value. If you need an updating timestamp, delete the static entry and use the formula =TODAY() for the date or =NOW() for the date and time. Recalculate these formulas by pressing F9.
Time Appears as a Decimal Number
The cell may have a General or Number format. Select the cell, go to Home > Number Format dropdown, and choose Time. You can also press Ctrl+1 to open the Format Cells dialog and select a time format from the Number tab.
Shortcut Only Works in One Cell at a Time
After using the shortcut, Excel exits edit mode. To use it again in another cell, you must first select that new cell. You cannot use the shortcut repeatedly by just pressing Enter and then the shortcut again. Press F2 to edit a cell, then use the shortcut to replace its contents.
Keyboard Shortcuts vs Functions: Key Differences
| Item | Ctrl+; and Ctrl+Shift+; (Shortcuts) | TODAY() and NOW() (Functions) |
|---|---|---|
| Value Type | Static, fixed entry | Dynamic, volatile formula |
| Updates When File Opens | No | Yes |
| Cell Contents | A constant number | A formula that recalculates |
| Use Case | Recording historical data | Creating live timestamps or age calculations |
| Keyboard Entry Speed | Instant insertion | Requires typing = and parentheses |
You can now insert timestamps instantly without looking away from your keyboard. Use Ctrl+; for invoices and Ctrl+Shift+; for time logs. For a dynamic header that always shows the current date, try using the TODAY function. To quickly apply a different date format, select your cells and press Ctrl+1 to open the full Format Cells dialog.