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: 

          

1 Comments on this post

Trackbacks

  1. strugar said:

    Well, I don’t frequently need to insert today’s date, but nice to know, thanks.

    My favourite ones:
    Ctrl + space to select the column
    Ctrl + 1 to invoke “Format cells” dialog
    Shift + space to select the row
    Alt + E followed by D to delete row or column if they’re selected or to invoke “Delete” dialog if not selected.
    Context menu key + S for Paste Special dialog; folowed by F, V or T to paste formulas, values or formats (most frequently used).
    F11 to turn selection into chart
    F2 to edit cell
    F9 to recalculate
    Alt + O followed by H and R to rename the sheet.
    Alt + O followed by H and U to invoke “Unhide sheet” dialog.
    Ctrl + Page up / Page down to navigate between sheets; hold down Shift to select.
    Ctrl + arrow up/arrow down to move from active cell untill first empty cell upwards or downwards; hold down Shift to select.

    Probably more, but can’t remeber at the moment…

    January 16th, 2015 at 9:50 am

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives