Using NOW function refreshes each time when you make entry to worksheet. Hence, I dont prefer to use NOW function. I use shortcut key to enter time or Date to worksheet. This trick is helpful in saving time.
For Time
Shortcut key: Ctrl + Shift + ;
For Date
Shortcut key: Ctrl + ;
Please do let me know your comments about my attempt to help beginners with Shortcut key to enter date and time. Also, you can subscribe via email
We assure you knowledge, not SPAM!
0 comments:
Post a Comment