Adding Automatic update Current Date and Time Stamp in Excel

Adding Current Date and Time Stamp in Excel

Sometimes it happens that you might want to enter the current date and time stamp in your excel spreadsheets automatically. This need usually arrives because of various reasons, in my case I was urged to find a solution to it as I need to do some team management wherein I required the time my associates are spending on work daily. So, in this case adding the current date and time stamp manually is a very tedious task. Thanks to MS Excel that there are certain functions and keyboard shortcuts to do it on the fly.
Now, let’s jump quickly onto the actual topic of adding current date and time stamp in excel. There are three simple ways as listed below of doing it. You can follow anyone of them depending on your needs.

Method 1. Add Current Date using Keyboard Shortcut

Brief about Keyboard Shortcut (Ctrl + ;):

• The main advantages of using this method is that being a keyboard shortcut it’s pretty much handy and easier to use multiple times.
• Its output gives you only current date no time stamp. Hence if you need only the date then you can quickly go for it.
• It does not get refreshed after opening the spreadsheet every time. Hence if you are looking for a feature just to add current date without getting it refreshed then you should select this method.

How to Use it:
Below listed steps have to be followed to use Current Date using a Keyboard Shortcut:

• Click on cell wherein you want to add current date.
• Right click on the selected cell and select “FORMAT CELLS” option.
• Select “Category” as date.
• Click on “OK” button once you are done with the formatting.
• Now click on the formatted cell and press and hold “Ctrl Key” on Keyboard along with this press semi-colon key (;)
• Release “Semi-Colon Key” and “Ctrl Key” of keyboard.
• After this you will be able to see the current date in the cell as depicted in below image

If you need the date to be updated every time you open excel then this shortcut will not be able to help you out. However, don’t lose heart we have more functions Contact us: click HERE  Send  EMAIL. Phone Number:  0787236867

Tally ERP 9 and Advanced Excel Training

Tally ERP 9 and Advanced Excel Training