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.

excel add timestamp to sheet entry

To do it in Excel, here is the answer:

a) Select the cell. Click on "Ctrl + ;" to get the System Date as shown below.

excel excel add timestamp to sheet entry

b) Enter comma followed by space and then press "Ctrl + Shift + ;". System time is also added as shown below.

excel excel excel add timestamp to sheet entry

 

You can find similar Excel Questions and Answer hereunder

1) How can I add a Footer to my printout with automatic page numbering?

2) How can I add a 3 Month Moving average Trend line to my line chart?

3) Vba clear the contents of an entire sheet in Excel

4) How do I add a shape using VBA?

5) I am planning to protect my sheet using a password. However, for select cells I would like users to be able to edit the cells. In Excel, how can I achieve that?

6) How can I prevent edits on my worksheet by protecting it with a Password ?

7) How can I add a legend to a chart using VBA?

8) How do I enter a formula in a cell using VBA (using Absolute Reference)?

9) I want to add a trend indicator symbol next to my sales data - how can I do that?

10) How can I add a Timestamp after macro execution?

11) How can I hide a sheet completely from users (the sheet should not even appear in Unhide dialog box)?

12) How do I enter a formula in a cell using VBA (using Relative Reference)?

13) How can I add Trendline to a chart using VBA?

14) I have entered lot of comments in my WorkSheet - how do I have them show up when printed?

15) How can I add a WorkSheet and name it as required using VBA?