Monday, June 16, 2008

Tip # 40 Enter a fixed time into Excel

If you want Excel to enter the current date or time and fix it at that point – for example, to show the last date the sheet was modified – click on a cell and press [Ctrl] + [;] for the date and [Ctrl] + [:] for the time.