Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the shortcut key to insert system date in a cell (Excel)?

user-image
Question added by Syed Aneel Raza , Customer Service Representative , ARY Services (Pvt)
Date Posted: 2016/10/22
mikdad hussain
by mikdad hussain , Accountant , Al Haddah Ttading And contracting Co

in excel worksheet select the cell in which you want to insert the current system date

To insert the current date 

Press Ctrl+; ( Semi-colon)

Asif Rahman
by Asif Rahman , Accountant , Wadi Al Shaam Auto Spare Parts Trading

ctrl+shift: for time

ctrl+; for date

 

Mohammad Amr
by Mohammad Amr , مدير قسم سلسلة التوريد , شركة الرازي الطبية

put in the cell that you want to show the today dat this function

=TODAY()

Deleted user
by Deleted user

you can use   Ctrl + ;

 

good luck

More Questions Like This