Entering data
ENTER
Complete a cell entry and select the cell below.
ALT+ENTER
Start a new line in the same cell.
CTRL+ENTER
Fill the selected cell range with the current entry.
SHIFT+ENTER
Complete a cell entry and select the previous cell above.
TAB
Complete a cell entry and select the next cell to the right.
SHIFT+TAB
Complete a cell entry and select the previous cell to the left.
ESC
Cancel a cell entry.
Arrow keys
Move one character up, down, left, or right.
HOME
Move to the beginning of the line.
F4 or CTRL+Y
Repeat the last action.
CTRL+SHIFT+F3
Create names from row and column labels.
CTRL+D
Fill down.
CTRL+R
Fill to the right.
CTRL+F3
Define a name.
CTRL+K
Insert a hyperlink.
CTRL+; (semicolon)
Enter the date.
CTRL+SHIFT+: (colon)
Enter the time.
ALT+DOWN ARROW
Display a drop-down list of the values in the current column of a range.
CTRL+Z
Undo the last action.

Here are some keyboard shortcuts to help you work with macros

ALT+F8
Displays the Macro dialog box.

ALT+F11
Displays the Visual Basic Editor.

CTRL+F11
Inserts a Microsoft Excel 4.0 macro sheet.

Keyboard Shortcut To Identify Cells Referenced By A Formula

This is a ‘quick and dirty’ tip for troubleshooting the cell references in your formulas.

Excel offers options to trace (precedent) cells referenced by formulas or trace the (dependent) cells that contain formulas that refer to the active cell. In Excel 2003, click View, Toolbars, Formula Auditing. In Excel 2007, click the Formulas tab and you’ll see the Trace Precedents and Trace Dependents commands in the Formula Auditing group. Clicking on these commands will draw arrows pointing to the cells referenced by the formula in the Active Cell.

However, if you simply want a quick way to find out which cells a formula refers to, pressing CTRL + [ (opening bracket) will select the cells that the formula in the active cell directly refers to.

There is also a similar trick you can use to trace dependant cells (cells that depend on a cell's value) . Pressing CTRL + ] (closing bracket) will select the cells (rather than draw arrows) that directly depend on the original cell.

In both cases, subsequent pressing of the keyboard shortcut will trace to the next level.

Once the referenced cells are selected, you may want to view the contents of each of these cells. Pressing the Tab key on your keyboard to tab through each cell.