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

Excel Keyboard Shortcuts - Handy during day to day work

Alternative for SUMIF and SUMIFS - Part 2 (SUMPRODUCT)