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

Alternative for SUMIF and SUMIFS

Solving issues with "VLOOKUP"

Excel Keyboard Shortcuts - Handy during day to day work