Bayt.com

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)?

Microsoft Excel Microsoft Office
user-image
Question added by Syed Aneel Raza , Customer Service Representative , ARY Services (Pvt)
Date Posted: 2016/10/22
Upvote (0) Views (10) Followers (4) Answers (4) Report Question
Write an Answer
Register now or log in to answer.
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

Write Your Answer
More Questions Like This