Today, Microsoft Excel has become a very important part of corporate life.. If you know about the keyboard shortcuts for using the Microsoft Excel, it will be an advantage and will save much of your time.
In this article, you’ll learn how to insert current date and time by using the keyboard shortcut in Microsoft Excel.
There are 2 ways to enter the current date and current time in Microsoft Excel.
Current Date through Keyboard shortcut
Follow below given steps:-
Current Date by using Today function
Follow below given steps:-
Note: - The difference between keyboard shortcut and Today function is that today function will change the date every day, but the date which we have entered through keyboard shortcut will never change.
Current time through Keyboard shortcut
Follow below given steps:-
Current time through Now function
Follow below given steps:-
In this way, we can use keyboard shortcut to insert the current date and current time in Microsoft Excel.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
