Keyboard shortcut to insert Current Date / Current Time

 

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.

  • Keyboard shortcut
  • Functions

Current Date through Keyboard shortcut

Follow below given steps:-

  • Select any cell
  • Press Ctrl+; on your keyboard
  • Press Enter

image 1

 

Current Date by using Today function

Follow below given steps:-

  • Enter the function in cell C7
  • =TODAY()
  • Press Enter

image 2

 

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:-

  • Select any cell
  • Press Ctrl+Shift+; on your keyboard
  • Press Enter

image 3

 

Current time through Now function

Follow below given steps:-

  • Enter the function in cell C9
  • ==MOD(NOW(),1)
  • Press Enter
  • Format cell as hh:mm

image 4

 

In this way, we can use keyboard shortcut to insert the current date and current time in Microsoft Excel.

 

image 48

 

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

 
 



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>