bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Editing > Entering the Current Time

Entering the Current Time

Summary: Want to enter the current time into a cell? It’s easy with the shortcut described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Some people like to use Excel to keep track of the time that they work on different jobs. If you want a quick way to enter the current time, simply select a cell and press Ctrl+: (that's the colon). Obviously, to access the colon you need to hold down the Shift key, so some people might express this shortcut as Shift+Ctrl+:. The result is that Excel places the current system time in the selected cell. All you need to do is press Enter to accept the time.

Tip #2616 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007


More Power! Expand your skills and make Excel really sing! It's all possible with macros. The best resource anywhere for macros is ExcelTips: The Macros. Check it out today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)