Microsoft Office Tutorials and References
In Depth Information
Function keys
F5
Displays the Go To dialog box.
CTRL+F5 restores the window size of the selected workbook window.
F6
Switches between the worksheet, ribbon, task pane, and Zoom controls. In a worksheet that
has been split (View menu, Manage This Window, Freeze Panes, Split Window command),
F6 includes the split panes when switching between panes and the ribbon area.
SHIFT+F6 switches between the worksheet, Zoom controls, task pane, and ribbon.
CTRL+F6 switches to the next workbook window when more than one workbook window is
open.
F7
Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
.
F8
Turns extend mode on or off. In extend mode, Extended Selection appears in the status line,
and the arrow keys extend the selection. Extend mode allows you to select consecutive cell
with the keyboard arrow keys without requiring you to hold down the Shift key. Tapping F8 a
second time toggles this command off.
SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the
arrow keys. That is, after having selected one range, tapping this shortcut lets you click
elsewhere and drag or key-select another range, even as the original range remains selected.
ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro.
F9
Calculates all worksheets in all open workbooks.You’ll rarely use this one nowadays.You
might, however, if your workbook features thousands of formulas which are going to be
recurrently impacted by new data entry. On a slow computer, that process can be rather
time-consuming. If this is the case, you can click Formulas Calculation Calculation
Options Manual, which prevents Excel from recalculating formulas when you enter new
data. F9 will then calculate the worksheet when pressed. The Calculate Now button on the
Calculation button group calculates the workbook in which you’ve clicked. Note that when
you enter new data in manual calculation mode, a “Calculate” prompt will appear in the
lower left of the status bar, reminding you that you’ve entered new data which needs to be
recalculated. That’s a good thing to know, because if you overlook the need to recalculate,
you’ll be working with “old” data – that is, you’ll be proceeding with values which have yet to
be updated.
SHIFT+F9 calculates the active worksheet only. If, however, other worksheets in the
workbook refer to values in that active sheet, they won’t be updated by this command.
CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they
have changed since the last calculation.
CTRL+F9 minimizes a workbook window to an icon.
F10
Turns key tips on the ribbon on or off. Pressing ALT does the same thing.
SHIFT+F10 displays the shortcut menu for a selected item.
CTRL+F10 maximizes or restores the selected workbook window, equivalent to clicking the
lower tier of maximnize-minimize buttons in the upper right of your screen.
Search JabSto ::




Custom Search