add timestamp to sheet entry in Excel
Q75. Every time I make an update to my Worksheet, I would like to add a timestamp to my "Last Updated" field. In Excel, how can I do that in Worksheet?
For example, in the "Last Updated On" field in my Worksheet as shown below, I would like to enter the System Date and Sytem Time (not manually). I understand Today() and Now() are volatile functions and they keep changing.
To do it in Excel, here is the answer:
a) Select the cell. Click on "Ctrl + ;" to get the System Date as shown below.
b) Enter comma followed by space and then press "Ctrl + Shift + ;". System time is also added as shown below.