Excel Trick

If you need to add the current data and/or time in Excel, there are two ways. One is to use the now(), date() or time() functions if you want the date and time to always be your current PC time (i.e. a dynamic date). However, if you want to just enter a static current time, such as a manual time stamp for an entry, you can use Ctrl and “;”. As per the manual:
Current date - Select a cell and press CTRL+; Current time - Select a cell and press CTRL+SHIFT+;Current date and time - Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+;