Keys for moving and scrolling in a worksheet or workbook

Press	To
Arrow keys	Move one cell up, down, left, or right
CTRL+arrow key	Move to the edge of the current data region
HOME	Move to the beginning of the row
CTRL+HOME	Move to the beginning of the worksheet
CTRL+END	Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
PAGE DOWN	Move down one screen
PAGE UP	Move up one screen
ALT+PAGE DOWN	Move one screen to the right
ALT+PAGE UP	Move one screen to the left
CTRL+PAGE DOWN	Move to the next sheet in the workbook
CTRL+PAGE UP	Move to the previous sheet in the workbook
CTRL+F6 or CTRL+TAB	Move to the next workbook or window
CTRL+SHIFT+F6 or CTRL+SHIFT+TAB	Move to the previous workbook or window
F6	Move to the next pane in a workbook that has been split
SHIFT+F6	Move to the previous pane in a workbook that has been split
CTRL+BACKSPACE	Scroll to display the active cell
F5	Display the Go To dialog box
SHIFT+F5	Display the Find dialog box
SHIFT+F4	Repeat the last Find action (same as Find Next)
TAB	Move between unlocked cells on a protected worksheet

Keys for moving in a worksheet with End mode on

Press	To
END	Turn End mode on or off
END, arrow key	Move by one block of data within a row or column
END, HOME	Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
END, ENTER	Move to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command)

Press	To
SCROLL LOCK	Turn SCROLL LOCK on or off
HOME	Move to the cell in the upper-left corner of the window
END	Move to the cell in the lower-right corner of the window
UP ARROW or DOWN ARROW	Scroll one row up or down
LEFT ARROW or RIGHT ARROW	Scroll one column left or right

Press	To
SHIFT+F11 or ALT+SHIFT+F1	Insert a new worksheet
F11 or ALT+F1	Create a chart that uses the current range
ALT+F8	Display the Macro dialog box
ALT+F11	Display the Visual Basic Editor
CTRL+F11	Insert a Microsoft Excel 4.0 macro sheet
CTRL+PAGE DOWN	Move to the next sheet in the workbook
CTRL+PAGE UP	Move to the previous sheet in the workbook
SHIFT+CTRL+PAGE DOWN	Select the current and next sheet in the workbook
SHIFT+CTRL+PAGE UP	Select the current and previous sheet in the workbook

Press	To
ENTER	Complete a cell entry and move down in the selection
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 move up in the selection
TAB	Complete a cell entry and move to the right in the selection
SHIFT+TAB	Complete a cell entry and move to the left in the selection
ESC	Cancel a cell entry
BACKSPACE	Delete the character to the left of the insertion point, or delete the selection
DELETE	Delete the character to the right of the insertion point, or delete the selection
CTRL+DELETE	Delete text to the end of the line
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
SHIFT+F2	Edit a cell comment
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

Keys for working in cells or the formula bar

Press	To
BACKSPACE	Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents
ENTER	Complete a cell entry
CTRL+SHIFT+ENTER	Enter a formula as an array formula
ESC	Cancel an entry in the cell or formula bar
CTRL+A	Display the Formula Palette after you type a function name in a formula
CTRL+SHIFT+A	Insert the argument names and parentheses for a function after you type a function name in a formula
CTRL+K	Insert a hyperlink
ENTER (in a cell with a hyperlink)	Activate a hyperlink
F2	Edit the active cell and position the insertion point at the end of the line
F3	Paste a defined name into a formula
SHIFT+F3	Paste a function into a formula
F9	Calculate all sheets in all open workbooks
CTRL+ALT+F9	Calculate all sheets in the active workbook
SHIFT+F9	Calculate the active worksheet
= (equal sign)	Start a formula
ALT+= (equal sign)	Insert the AutoSum formula
CTRL+; (semicolon)	Enter the date
CTRL+SHIFT+: (colon)	Enter the time
CTRL+SHIFT+" (quotation mark)	Copy the value from the cell above the active cell into the cell or the formula bar
CTRL+` (single left quotation mark)	Alternate between displaying cell values and displaying cell formulas
CTRL+' (apostrophe)	Copy a formula from the cell above the active cell into the cell or the formula bar
ALT+DOWN ARROW	Display the AutoComplete list