Home › Excel shortcuts

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

ActionWindowsMac
Insert today's dateCtrl+;⌃;
Insert current timeCtrl+Shift+;⌘;
Fill downCtrl+D⌘D or ⌃D
Edit the active cellF2⌃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.

Practise these and 30 more: play the shortcut trainer → or see the full cheat sheet.

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.

More shortcut guides

Insert & delete rows and columnsMerge & Center and Wrap TextPaste values onlyUndo, redo and repeatHide & unhide rows and columnsAutoSum shortcutStrikethrough shortcutSwitch, add and rename sheets