Input Current Date and Time in Excel Spreadsheets

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).

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.