Insert today's date and time
Press Ctrl+; to type today's date into a cell, and Ctrl+Shift+; for the current time (Cmd+; on Mac). The value is fixed: it won't change tomorrow. If you want a date that always shows today, use the TODAY() formula instead.
Try it: press the keys on this sheet
Windows and Mac keys
| Action | Windows | Mac |
|---|---|---|
| Insert today's date | Ctrl+; | ⌃; |
| Insert current time | Ctrl+Shift+; | ⌘; |
| Fill down | Ctrl+D | ⌘D or ⌃D |
| Edit the active cell | F2 | ⌃U |
Shortcut not working?
The date shows as a number like 46340
The cell is formatted as a number. Press Ctrl+Shift+3 or use Format Cells to apply a date format.
Ctrl+; doesn't work on my keyboard
On some layouts the semicolon needs Shift. Try Ctrl+Shift+; for the date on those keyboards, or type =TODAY() and convert it to a value with paste values.
I need the date and time in one cell
Press Ctrl+;, then a space, then Ctrl+Shift+;, then Enter.
Frequently asked questions
What is the shortcut for today's date in Excel?
Ctrl+; (Ctrl and semicolon) on Windows and Mac. It enters a fixed date that won't change.
What is the shortcut for the current time?
Ctrl+Shift+; on Windows and Cmd+; on Mac.
What's the difference between Ctrl+; and TODAY()?
Ctrl+; types a fixed date. =TODAY() is a formula that always shows the current date and changes every day the file is opened.