EXCEL GUIDE

	Enter data by using shortcut keys
	To	Press
	Complete a cell entry	ENTER
	Cancel a cell entry	ESC
	Repeat the last action	F4 or CTRL+Y
	Start a new line in the same cell	ALT+ENTER
	Delete the character to the left of the insertion point, or delete the selection	BACKSPACE
	Delete the character to the right of the insertion point, or delete the selection	DELETE
	Delete text to the end of the line	CTRL+DELETE
	Move one character up, down, left, or right	Arrow keys
	Move to the beginning of the line	HOME
	Edit a cell comment	SHIFT+F2
	Create names from row and column labels	CTRL+SHIFT+F3
	Fill down	CTRL+D
	Fill to the right	CTRL+R
	Fill the selected cell range with the current entry	CTRL+ENTER
	Complete a cell entry and move down in the selection	ENTER
	Complete a cell entry and move up in the selection	SHIFT+ENTER
	Complete a cell entry and move to the right in the selection	TAB
	Complete a cell entry and move to the left in the selection	SHIFT+TAB
	Work in cells or the formula bar by using shortcut keys
	To	Press
	Start a formula	= (EQUAL SIGN)
	Cancel an entry in the cell or formula bar	ESC
	Edit the active cell	F2
	Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents	BACKSPACE
	Paste a name into a formula	F3
	Define a name	CTRL+F3
	Calculate all sheets in all open workbooks	F9
	Calculate the active worksheet	SHIFT+F9
	Insert the AutoSum formula	ALT+= (EQUAL SIGN)
	Enter the date	CTRL+; (SEMICOLON)
	Enter the time	CTRL+SHIFT+: (COLON)
	Insert a hyperlink	CTRL+K
	Complete a cell entry	ENTER
	Copy the value from the cell above the active cell into the cell or the formula bar	CTRL+SHIFT+" (QUOTATION MARK)
	Alternate between displaying cell values and displaying cell formulas	CTRL+` (SINGLE LEFT QUOTATION MARK)
	Copy a formula from the cell above the active cell into the cell or the formula bar	CTRL+' (APOSTROPHE)
	Enter a formula as an array formula	CTRL+SHIFT+ENTER
	Display the Formula Palette after you type a valid function name in a formula	CTRL+A
	Insert the argument names and parentheses for a function, after you type a valid function name in a formula	CTRL+SHIFT+A
	Display the AutoComplete list	ALT+DOWN ARROW