Do you need to quickly copy an “above” cell value to a current cell? All you have to do is press CTRL + SHIFT + ” to copy the above cells contents into the current cell.

Need to quickly create a Microsoft Excel formula to get the sum of all cells? Simply highlight the cells you want to know the value of and press ALT + =.

Need to add the current time to your Excel document? Hit the “Control” button and the colon key at the same time.

Save some time! To select multiple cells with the keyboard (instead of the mouse), simply hold down the Shift key and use your cursor keys.

Need to copy some complex formatting? Use the Format Painter (the little paintbrush button on the Standard Toolbar). Find the formatting you want to copy. Click the Paintbrush and then click the cell you want apply it to.

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.