Insert the current date in Excel – Keyboard Shortcut
- 1 Comment
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.