Entering Date and Time in Excel

There are shortcuts to enter

  • the current Date Ctr + ;
  • the current Time Ctrl + Shift + :

There isn’t one to enter both.

You can use them in sequence to achieve a date and a time entry.

In sequence press

Ctrl + ;

Space bar

Ctrl + Shift + :

The space separates the date and time and Excel will recognise the entry as a date and time.

Please note: I reserve the right to delete comments that are offensive or off-topic.