"How To Excel" Mini-Tutorials|
"Helping Average Excel Users Become Local Spreadsheet Experts"
Insert Time and Date Stamps In Your Worksheet
Anytime you need to insert the current time or date into your spreadsheet here's the quickest way to do it.
- For the current date press CTRL+semicolon.
- For the current time press CTRL+SHIFT+semicolon.
- For both current date and time in a cell press CTRL+semicolon, then press the SPACEBAR, then CTRL+SHIFT+semicolon, then ENTER.
Why not print (CTRL+P) this tip and share it with your friends and associates?
Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.|
Copyright © 2003 All Rights Reserved by Francis Hayes (The Excel Addict)