|
Key |
Description |
|
F1 |
Displays the Help task
pane.
CTRL+F1 closes and
reopens the current task pane.
ALT+F1 creates a chart
of the data in the current range.
ALT+SHIFT+F1 inserts a
new worksheet. |
|
F2 |
Edits the active cell and
positions the insertion point at the end of the cell contents. It also
moves the insertion point into the Formula Bar when editing in a cell is
turned off.
SHIFT+F2 edits a cell
comment. |
|
F3 |
Pastes a defined name into a
formula.
SHIFT+F3 displays the
Insert Function dialog box. |
|
F4 |
Repeats the last command or
action, if possible.
CTRL+F4 closes the
selected workbook window. |
|
F5 |
Displays the Go To
dialog box.
CTRL+F5 restores the
window size of the selected workbook window. |
|
F6 |
Switches to the next pane in
a worksheet that has been split (Window menu, Split
command).
SHIFT+F6 switches to the
previous pane in a worksheet that has been split.
CTRL+F6 switches to the
next workbook window when more than one workbook window is open.
Note When the
task pane is visible, F6 and SHIFT+F6 include that pane when switching
between panes. |
|
F7 |
Displays the Spelling
dialog box to check spelling in the active worksheet or selected range.
CTRL+F7 performs the
Move command on the workbook window when it is not maximized. Use
the arrow keys to move the window, and when finished press ESC. |
|
F8 |
Turns extend mode on or off.
In extend mode, EXT appears in the status line, and the arrow
keys extend the selection.
SHIFT+F8 enables you to
add a non-adjacent cell or range to a selection of cells by using the
arrow keys.
CTRL+F8 performs the
Size command (on the Control menu for the workbook window)
when a workbook is not maximized.
ALT+F8 displays the
Macro dialog box to run, edit, or delete a macro. |
|
F9 |
Calculates all worksheets in
all open workbooks.
F9 followed by ENTER (or
followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected
a portion of a formula and replaces the selected portion with the
calculated value.
SHIFT+F9 calculates the
active worksheet.
CTRL+ALT+F9 calculates
all worksheets in all open workbooks, regardless of whether they have
changed since the last calculation.
CTRL+ALT+SHIFT+F9
rechecks dependent formulas, and then calculates all cells in all open
workbooks, including cells not marked as needing to be calculated.
CTRL+F9 minimizes a
workbook window to an icon. |
|
F10 |
Selects the menu bar or
closes an open menu and submenu at the same time.
SHIFT+F10 displays the
shortcut menu for a selected item.
ALT+SHIFT+F10 displays
the menu or message for a smart tag. If more than one smart tag is
present, it switches to the next smart tag and displays its menu or
message.
CTRL+F10 maximizes or
restores the selected workbook window. |
|
F11 |
Creates a chart of the data
in the current range.
SHIFT+F11 inserts a new
worksheet.
ALT+F11 opens the Visual
Basic Editor, in which you can create a macro by using Visual Basic for
Applications (VBA).
ALT+SHIFT+F11 opens the
Microsoft Script Editor, where you can add text, edit HTML tags, and
modify any script code. |
|
F12 |
Displays the Save As
dialog box. |
