COMPUTER GUIDE

Function keys in Microsoft Excel
Function Key		SHIFT	CTRL	ALT	CTRL+SHIFT	ALT+SHIFT
F1	Display Help or the Office Assistant	What's This?		Insert a chart sheet		Insert a new worksheet
F2	Edit the active cell	Edit a cell comment		Save As command		Save command
F3	Paste a name into a formula	Paste a function into a formula	Define a name		Create names by using row and column labels
F4	Repeat the last action	Repeat the last Find (Find Next)	Close the window	Exit
F5	Go To	Display the Find dialog box	Restore the window size
F6	Move to the next pane	Move to the previous pane	Move to the next workbook window		Move to the previous workbook window
F7	Spelling command		Move the window
F8	Extend a selection	Add to the selection	Resize the window	Display the Macro dialog box
F9	Calculate all sheets in all open workbooks	Calculate the active worksheet	Minimize the workbook
F10	Make the menu bar active	Display a shortcut menu (right click)	Maximize or restore the workbook window
F11	Create a chart	Insert a new worksheet	Insert a Microsoft Excel 4.0 macro sheet	Display Visual Basic Editor
F12	Save As command	Save command	Open command		Print command

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

Format data by using shortcut keys
To	Press
Display the Style command (Format menu)	ALT+' (APOSTROPHE)
Display the Cells command (Format menu)	CTRL+1
Apply the General number format	CTRL+SHIFT+~
Apply the Currency format with two decimal places (negative numbers appear in parentheses)	CTRL+SHIFT+$
Apply the Percentage format with no decimal places	CTRL+SHIFT+%
Apply the Exponential number format with two decimal places	CTRL+SHIFT+^
Apply the Date format with the day, month, and year	CTRL+SHIFT+#
Apply the Time format with the hour and minute, and indicate A.M. or P.M.	CTRL+SHIFT+@
Apply the Number format with two decimal places, 1000 separator, and – for negative values	CTRL+SHIFT+!
Apply the outline border	CTRL+SHIFT+&
Remove all borders	CTRL+SHIFT+_
Apply or remove bold formatting	CTRL+B
Apply or remove italic formatting	CTRL+I
Apply or remove an underline	CTRL+U
Apply or remove strikethrough formatting	CTRL+5
Hide rows	CTRL+9
Unhide rows	CTRL+SHIFT+(
Hide columns	CTRL+0 (ZERO)
Unhide columns	CTRL+SHIFT+)
Edit data by using shortcut keys
To	Press
Edit the active cell	F2
Cancel an entry in the cell or formula bar	ESC
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
Complete a cell entry	ENTER
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
Insert, delete, and copy a selection by using shortcut keys
To	Press
Copy the selection	CTRL+C
Paste the selection	CTRL+V
Cut the selection	CTRL+X
Clear the contents of the selection	DELETE
Insert blank cells	CTRL+SHIFT+PLUS SIGN
Delete the selection	CTRL+ –
Undo the last action	CTRL+Z
Move within a selection by using shortcut keys
To	Press
Move from top to bottom within the selection (down), or in the direction that is selected on the Edit tab (Tools menu, Options command)	ENTER
Move from bottom to top within the selection (up), or opposite to the direction that is selected on the Edit tab (Tools menu, Options command)	SHIFT+ENTER
Move from left to right within the selection, or move down one cell if only one column is selected	TAB
Move from right to left within the selection, or move up one cell if only one column is selected	SHIFT+TAB
Move clockwise to the next corner of the selection	CTRL+PERIOD
Move to the right between nonadjacent selections	CTRL+ALT+RIGHT ARROW
Move to the left between nonadjacent selections	CTRL+ALT+LEFT ARROW