Insert date in Excel shortcut

Windows

Mac

Ctrl+; enters today’s date as a fixed value. Ctrl+Shift+; (Cmd+; on Mac) enters the current time.

Variants and related combos

Where / whatWindowsMac
Current time

Good to know

  • The value will not change tomorrow; use =TODAY() for a date that updates.

Source: Microsoft Support: Keyboard shortcuts in Excel.

Try it now

Click the pad below, then press the shortcut. Nothing happens to this page; we just listen.

Waiting for your keys…

Practise it with the rest of the set

One shortcut sticks better alongside its neighbours. These trainers include it:

Questions

What is the insert date in excel shortcut?

Ctrl+; enters today’s date as a fixed value. Ctrl+Shift+; (Cmd+; on Mac) enters the current time.

More quick answers