Excel: Want to display the current date? Press Ctrl + semicolon (;). The current time? Ctrl + Shift + semicolon. Note: using this method, the date and time are static (don't update). If you want the date or time to update, then use formulas. =today() will give you the current date. =now() will give you the date and time (can be formatted to show only the time). Selecting the cell and pressing the F9 key will cause the date or time to refresh and give the most current information.
Have any good tips you'd like to share? E-mail me Jordan@helpmejordan.com