To quickly go to the last cell with data in it, hit CTRL-END. CTRL-HOME always takes you to cell A1. Very helpful in HUGE spreadsheets!

To edit the active cell, hit F2. It’s much faster than double-clicking on it.

Need to see the gridlines on a printed copy of your spreadsheet? Don’t draw borders. Just pull down the File menu, choose “Page Setup,” click the “Sheet” tab, and check “Gridlines” under the Print heading.  In Excel 2007, click Page Layout, and check the Print Box under Gridlines.

Select multiple, non-contiguous cells by holding down the Ctrl key while you click! Select a range of cells by holding down the Shift key while clicking. Works in Word, Access, and PowerPoint!

Sometimes you want to see how changing one cell affects others. Instead of jumping all over a worksheet finding the differences, simply turn on the Watch Window toolbar. In Excel 2003, right-click on any toolbar and click on “Watch Window.” In Excel 2007 and higher, click the Formulas menu item, and then “Watch Window” in the “Formula Auditing” box.

Work on the same workbook with someone else simultaneously! Pull down the Review menu and choose “Share Workbook…”. Talk about “group collaboration!”

Toggle Absolute Reference options by hitting F4 right after typing in a formula.

Hold down the Shift key while clicking on the Underline toolbar button to achieve a double-underline. Sweet!

Know the difference between “Delete” and “Clear Contents.” The latter erases all formulas while the former actually deletes the cells, forcing other cells to fill the gap.

Make your cells stand out. Pull down the Format menu and choose “Cells.” Then choose the “Pattern” tab. In Excel 2007 or higher, click the Home tab and then choose “Cell Styles.”