Single Keyboard Shortcut to Insert DATE  TIME

oaktrees
oaktrees used Ask the Experts™
on
Using Excel keyboard shortcuts

ctrl + semicolon yields the DATE
ctrl + shift + semicolon yields the TIME

both non-dynamic

Need a single keyboard shortcut that will insert

DATE TIME

Both, also non-dynamic

Thanks!

OT
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
You can achieve that with the help of VBA.
Place the below code on a Standard Module like Module1 and assign a shortcut key say Ctrl + Shift + D to it and save your file as Macro Enabled Workook. And you can press this shortcut key to insert the date time in the active cell.

In the attached, press the shortcut key Ctrl + Shift + D and the code will insert the Date and Time in the ActiveCell.
InsertDateAndTime.xlsm

Author

Commented:
Thanks! :)))!
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial