Easily undo multiple actions in Excel (2000/2001/2002/2003/2007)

If you're a longtime keyboard jockey, you probably instinctively use the [Ctrl]Z shortcut when you want to undo a change you've made. However, if you need to backtrack through many steps, you may not recall exactly how many steps you need to undo. Chances are you'll backtrack too far and then wind up redoing more steps than you had planned. The next time you find yourself in this situation, use the dropdown arrows on Excel's Undo and Redo buttons. These provide you with a running list of your recent actions so you can easily undo or repeat exactly the steps you want. (In Excel 2007, the Undo and Redo buttons still have a dropdown arrow. But you'll need to look for these buttons on your Quick Access Toolbar.)

Showing the current date and time in a worksheet cell (Excel 2000/2001/2002/2003/2007)

Sometimes there's an advantage to storing the current date or time in a worksheet cell. For instance, the worksheet's layout may lend itself to showing the date inline with the data, as opposed to in the header section. Or, your worksheet may use date-based formulas that process data according to the current date and time. Regardless of the reason, it's easy to create cells that display the current date and time.

To show the current day, just enter the following formula in a cell:
=TODAY()


To show the current date and time together, enter the formula:
=NOW()

You can change how the date and time appear by changing the cell's number format. For instance, you can format the NOW function result so that only the time portion is shown. To change the formatting, select the cell and choose Format | Cells from the menu bar. Then, click on the Number tab and select a format type from the Date or Time categories.