Jan 15 2015

Insert the current date in Excel – Keyboard Shortcut

There are so many useful keyboard shortcuts in Microsoft Excel.  Most of us have heard of ‘Ctrl‘ ‘Z‘ for undo. Perhaps ‘Ctrl‘ ‘C‘ for copy, or ‘Ctrl‘ ‘V‘ for paste.  But one of the most useful ones I personally use is ‘Ctrl‘ ‘;‘ to enter the current date.  Why type ‘01/15/2015‘ when you can hit two keys?  And unlike =Now() or =Today(), the ‘Ctrl‘ ‘;‘ will paste a value which will not change.

Not complicated, but definitely useful.  Once you learn this shortcut you will never type the current date again.

Please post your favorite keyboard shortcuts in the comments section.

 

Want to read more?  Here are three sites that have quality content on Excel keyboard shortcuts.

https://exceljet.net/keyboard-shortcuts/insert-current-date

http://www.lifehacker.com.au/2012/10/insert-todays-date-in-excel-with-a-handy-keyboard-shortcut

http://www.techrepublic.com/blog/microsoft-office/the-10-most-useful-excel-keyboard-shortcuts

 

 

More Excel Tips

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 

          

Comments are closed.

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives