« Build your own "Ugliest Motorcycle" | Main | MS Project Tip - Creating User-defined Filters »

Excel Keyboard Shortcuts for date and time

If you are doing any formulas or VBA programming in excel, you probably know about the now() function which returns the current date and time. The problem with Now() is that it is always changing so often it is easier to simply enter the date you want to use. I used to just use the formula =now() and then cut and paste special.

Fortunately there is a simple keyboard shortcut for doing this which you can use to insert the date and time anywhere you want (even within text).

To insert the current date hold down the CTRL key and then type a semicolon ; (CTRL+;)
To insert the current time hold down the CTRL key and then type a colon : (CTRL+Shift+:)

The correct date and time values will be inserted in the cell you are typing in.


Comments (1)


very Usefull so thanks

Post a comment

(Comments are moderated to fight SPAM and will be published after I have a chance to approve them. Thanks for waiting.)


The previous article is Build your own "Ugliest Motorcycle".

The next article is MS Project Tip - Creating User-defined Filters.

Current articles are in the main index page and you can find a complete list of articles in the archives.

Creative Commons License
This weblog is licensed under a Creative Commons License.
Powered by
Movable Type 3.34