Wednesday, December 10, 2014

Quick Current Date and Time in Excel

Excel-Quick-Date-Time
  • To enter Current Date in a cell Press Ctrl+; (semicolon ) it will inserts Current Date in your current Cell.
  • To enter Current Time  in a cell Press Ctrl+Shift+: (colon ) it will inserts Current Time in your current Cell.
Know you know, how to insert Current Date and Time Microsoft Excel, next time when need to insert Current Date and Time in any cell of worksheet and format the cell for Date and Time as like try these Keyboard Shortcuts.

This works in almost all the Excel versions.

Enjoy Microsoft Excel.

No comments:

Post a Comment