In Excel, you can make the row numbers and column letters appear on your printout. In the Page Setup dialog box (under Page Layout on the ribbon, or under the File menu in 2003 and earlier) click on the Sheet tab and put a tick beside Row and Column Headings.

In Excel, you can auto-print row and column headings on every page of a spreadsheet that runs over multiple pages. In the Page Setup dialog box (under Page Layout on the ribbon, or under the File menu in 2003 and earlier) click on the Sheet tab and you’ll find the Print Titles commands.

In Excel, the F12 key opens the Save As dialog box, which allows you to save your file under a new name.

In Excel, Shift+F11 will insert a new worksheet in front of the active sheet.

In Excel, the COUNT() function can be used to count “occupied” cells where the content is numeric. COUNTA() counts cells occupied by text. This is useful if you need to know how many items are in a list.

In Excel, when you’re working with a spreadsheet that’s larger than the area you can see on your monitor use the “Freeze Panes” command to freeze rows and/or columns to keep them in view. This allows you always to see headings while you scroll.

In Excel, Ctrl+F10 is a toggle command that will minimize or maximize the selected workbook window.

In Excel, the F5 key is “go to.” Hitting F5 opens a dialog box allows you to enter any cell reference or range name, and jump immediately to that location.

In Excel, the F7 key opens the Spelling dialog box, which will spell-check your document.

In the “My Documents” screen, you can quickly duplicate a file by using Ctrl + C to copy it, and Ctrl + V to paste it to a second location.

In the “My Documents” screen, use Ctrl + X to cut a file and Ctrl + V to paste it to a new location.

In the “My Documents” screen, you can rename files quickly by selecting the filename and hitting the F2 key.

In Excel, the F2 key edits the active cell. The insertion point is at the end of existing text. Note that the formula bar (which also contains the cell contents) becomes active too.

Most Excel commands exist in two places: the ribbon (the menu bar in 2003 and earlier versions), and as keyboard shortcuts. Here’s a complete list of Excel 2010 shortcuts.

The Windows clipboard is like a memo pad that allows pieces of information to be temporarily stored and then retrieved later by another application. The “copy” command moves content to the clipboard. The “paste” command retrieves and inserts it.