There are shortcuts to input the current date and the current time into cells.
To enter the current date, press Control + ; (semi-colon).
To enter the current time, press Control + Shift + : (colon).
To insert the current date and time, press Control + ; (semi-colon), then press Spacebar, and then press Control + Shift + ; (semi-colon).
Input Current Date and Time in Excel Spreadsheets
posted in: Shortcut of the Week
0
Leave a Reply