Part VII: Appendixes
954
TABLE D.7Function Keys
Key(s) What It Does
F1 Displays Help
Alt+F1 Inserts default chart object that uses the selected range
Alt+Shift+F1 Inserts a new worksheet
F2 Edits the active cell
Shift+F2 Edits a cell comment
Alt+F2 Equivalent to File ➪ Save As
Alt+Shift+F2 Equivalent to File ➪ Save
F3 Pastes a name into a formula
Shift+F3 Pastes a function into a formula
Ctrl+F3 Equivalent to Formulas ➪ Defined Names ➪ Name Manager
Ctrl+Shift+F3 Equivalent to Formulas ➪ Defined Names ➪ Create From Selection
F4 Repeats the last action
Shift+F4 Repeats the last Find (Find Next)
Ctrl+F4 Closes the window
Alt+F4 Equivalent to File ➪ Exit
F5 Equivalent to Home ➪ Editing ➪ Find & Select ➪ Go To
Shift+F5 Equivalent to Home ➪ Editing ➪ Find & Select ➪ Find
Ctrl+F5 Restores a minimized or maximized workbook window
Alt+F5 Refreshes active query or pivot table
F6 Moves to the next pane
Shift+F6 Moves to the previous pane
Ctrl+F6 Activates to the next window
Ctrl+Shift+F6 Activates the previous workbook window
F7 Equivalent to Review ➪ Proofing ➪ Spelling
Ctrl+F7 Allows moving the window with the arrow keys
F8 Extends a selection (toggle)
Shift+F8 Adds to the selection (toggle)
Ctrl+F8 Allows resizing the window with the arrow keys
Alt+F8 Equivalent to View ➪ Macros ➪ Macros, or Developer ➪ Code ➪ Macros
F9 Calculates all sheets in all open workbooks
Shift+F9 Calculates the active worksheet59_474877-bapp04.indd 95459_474877-bapp04.indd 954 3/29/10 11:47 PM3/29/10 11:47 PM