Shortcut to insert current date in a cell

Want to insert the current date in a cell with just a key stroke...?

The answer is simple - "ctrl + ;". This inserts the current system date as per the format configured on your system!

Check it out... this is applicable on all versions of excel.

Comments

Popular posts from this blog

Keyboard Shortcut to add/delete rows or columns in Excel

Alternative for SUMIF and SUMIFS

Shortcut to Copy the contents of the cell above or on the left