Excel: Date Time Shortcut
This is different from the previous tip, that updates the date and/or the time, every time you open Excel. This one will just enter the data in the cell without using a formula. This is a simple keyboard shortcut.
To enter today’s date: Press Ctrl & ; <—– (semicolon key)
To enter current time: Press Ctrl & Shift & : <—– (colon key)
Now you have today’s date or the current time. Unless you change it yourself, it will keep this data in the spreadsheet, without changing it.