Shortcut Keys

This is a list of all the shortcut keys related to dates and times.

Ctrl + ;Enters the current date into the active cell and applies the format "dd/mm/yyyy".
Ctrl + Shift + ;Enters the current time into the active cell and applies the format "hh:mm".
Ctrl + #Applies the Date format "dd-mmm-yy" to the selection.
Ctrl + Shift + #Applies the General number format to the selection. This can be used to display the serial number for a date.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext