F2 to edit the current cell.

Once a cell has been selected, you can use F4 to change the relative locations of cells.

Example: CELL = A2 + F4 => $A$2 + F4 => A$2

Ctrl + ; to enter current date

Ctrl + ' to copy cell above

Ctrl + D to copy down cells above selected cells

F2 to edit cell contents

Control+Page up or page down to go to next or previous worksheet.

When editing a formula: F9 to calculate the selected text

Ctrl + : enters the current time and Ctrl + ; enters the current date. Useful for call metrics forms.

Ctrl + . is one with little apparent use: it moves the active cell around the corners of the currently selected region. But once you get used to it, it comes in handy over and over again when your selection spans several page widths/heights and you know your next cursor operation is going to be close to one of the corners of the selection but is currently not there.

Alt + = = Auto sum a range of cells

= = Formula Mode

Ctrl + Shift + O = used to select Worksheet

ScrollLock – scroll the worksheet without moving the selection

Ctrl+Shift+` = Format as general

Ctrl+Shift+1 = Format as number

Ctrl+Shift+2 = Format as time

Ctrl+Shift+3 = Format as date

Ctrl+Shift+4 = Format as currency

Ctrl+Shift+5 = Format as percent

Ctrl+Shift+6 = Format as exponent

Ctrl + * : Select the whole table at once.

Ctrl + 1 to open the Format dialog.

Shift + F2 to add/edit a cell comment.

Shift + F2, followed by Esc to select the current cell comment, which can then be moved around with the arrow keys (←↑→↓) or deleted by pressing Del.

Ctrl + ←↑→↓ to move to the last non-blank cell in a series. This is usually the edge of a table, but not if you have blank cells in the path. Pressing End followed by an arrow key does the same thing.

Alt + F11 to open the VBA editor.

Alt + = to start a SUM() formula and go straight to selecting cells to be summed.

Ctrl + G or F5 to jump to a cell by typing its coordinates (e.g. C3)

Ctrl + Home to jump to the top left, usually A1 unless you you are in a frozen split view, in which case it will jump to the top left of the "data" area.

Ctrl + ; and Ctrl + Shift + ; to insert the current date and time, respectively. I know Ben Lings already posted this one, but I find it indispensable.

I use many of the ones up above, but in an attempt not to duplicate:

Ctrl+F3: Open the Names dialog box

1. Ctrl+` to toggle "view formulas" (it is the tilde key ~ to the left of the 1 on the keyboard)

2. Ctrl+Shift+Arrow keys will select to the last used cell in a row or column. For example, if you want to select a large list, click in the first cell you want and then ctrl+shift+rt arrow...then ctrl+shift+down arrow and it will select the whole list unless there are blanks in the last column. As an added benefit, the range shows up in the argument box for a function.

3. F11 creates the default chart on a separate sheet from the data you selected (Select data first then press F11).

4. Also, if you right click on the any of the arrow buttons near the sheet tabs, you'll get a list of your sheets and you can left click on the one you want to go to.

5. Not strictly a keyboard shortcut, but when you want to autofill down a column and there is a column to your immediate left or right that runs the exact length you want to autofill, place your mouse on the fill handle, but instead of dragging just double click.

Ctrl + N for new document

Ctrl + TAB for switching between documents

Ctrl + F4 or Ctrl + W for closing document

Ctrl + P for printing

Ctrl + R copies a formula/value to the right into the selected cell

Ctrl + D does the same from the above cell (down)

Esc gets rid of the annoying marquee around a copied cell