Microsoft Excel Shortcuts

[bbasujon]

Selections
Select the entire column. . . . . . . . . . . . . . .[Ctrl] + [Space]
Select the entire row. . . . . . . . . . . . . . . . . . .[Shift] + [Space]
Selects the entire worksheet. . . . . . . . . . . .[Ctrl] + [A]
If the worksheet contains data,
[Ctrl] + A selects the current region.
Pressing [Ctrl] + A a second time selects
the current region and its summary
rows. Pressing [Ctrl] + A a third time
selects the entire worksheet.
When the insertion point is to the right
of a function name in a formula, displays
the Function Arguments dialogue box
With multiple cells selected, select
only the active cell. . . . . . . . . . . . . . . . . . . . .[Shift] + [Backspace]
With an object selected, select all
objects on a sheet. . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Space]
Alternate between hiding objects,
displaying objects, and displaying
placeholders for objects. . . . . . . . . . . . . . . .[Ctrl] + [6]
Select the current region around the
active cell (the data area enclosed
by blank rows and blank columns).
In a PivotTable report, select the
entire PivotTable report. . . . . . . . . . . . . . . .[Ctrl] + [Shift] +

Select the array containing the active cell. [Ctrl] + [/]
(Array: Used to build single formulae
that produce multiple results or that
operate on a group of arguments that
are arranged in rows and columns.
An array range shares a common
formula; an array constant is a group
of constants used as an argument.)
Select all cells that contain comments. . .[Ctrl] + [Shift] +

In a selected row, select the cells that
don’t match the value in the active cell. .[Ctrl] + [\]
In a selected column, select the cells
that don’t match the value in the
active cell. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [|]
Select all cells directly referenced by
formulae in the selection. . . . . . . . . . . . . . .[Ctrl] + [[]
Select all cells directly or indirectly
referenced by formulae in the selection. .[Ctrl] + [Shift] + [{]
Select cells that contain formulae
that directly reference the active cell. . . .[Ctrl] + []]
Select cells that contain formulae that
directly or indirectly reference the
active cell. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [}]
Select the visible cells in the current
selection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Alt] + [;]
Add another range of cells to the selection. [Shift] + [F8]
Extend the selection by one cell. . . . . . . . .[Shift] + Arrow Key
Extend the selection to the last
nonblank cell in the same column
or row as the active cell. . . . . . . . . . . . . . . .[Ctrl] + [Shift] + Arrow Key
Extend the selection to the beginning
of the row. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Shift] + [Home]
Extend the selection to the beginning
of the worksheet. . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Home]
Extend the selection to the last used
cell on the worksheet (lower-right corner). .[Ctrl] + [Shift] + [End]
Extend the selection down one screen. . .[Shift] + [Page Down]
Extend the selection up one screen. . . . . .[Shift] + [Page Up]
Extend the selection to the last
nonblank cell in the same column or
row as the active cell. . . . . . . . . . . . . . . . . . .[End] + [Shift] + Arrow Key
Extend the selection to the last used
cell on the worksheet (lower-right corner). .[End] + [Shift] + [Home]
Extend the selection to the last cell
in the current row. This key sequence
does not work if you have turned on
transition navigation keys (Tools menu,
Options command, Transition tab). . . . . .[End] + [Shift] + [Enter]
Extend the selection to the cell in the
upper-left corner of the window. . . . . . . . .[Scroll Lock] + [Shift] + [Home]

[bbasujon]

Entering, Formatting And Calculations
Complete a cell entry and select the
cell below. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Enter]
Start a new line in the same cell. . . . . . . .[Alt] + [Enter]
Fill the selected cell range with the
current entry. . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Enter]
Complete a cell entry and select the
previous cell above. . . . . . . . . . . . . . . . . . . . .[Shift] + [Enter]
Complete a cell entry and select the
next cell to the right. . . . . . . . . . . . . . . . . . .[Tab]
Complete a cell entry and select the
previous cell to the left. . . . . . . . . . . . . . . . .[Shift] + [Tab]
Cancel a cell entry. . . . . . . . . . . . . . . . . . . . .[Esc]
Move one character up, down, left, or right. Arrow Keys
Move to the beginning of the line. . . . . . .[Home]
Repeat the last action if possible. . . . . . . .[F4] or [Ctrl] + [Y]
Fill down. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [D]
Fill to the right. . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [R]
Define a name. . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [F3]
Insert a hyperlink. . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [K]
Enter the date. . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [;]
Enter the time. . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [:]
Display a drop-down list of the values
in the current column of a range. . . . . . . .[Alt] + [Down Arrow]
Undo the last action. . . . . . . . . . . . . . . . . . .[Ctrl] + [Z]
Start a formula. . . . . . . . . . . . . . . . . . . . . . . .[=]
Move the insertion point into the
Formula Bar when editing in a cell
is turned off. . . . . . . . . . . . . . . . . . . . . . . . . . .[F2]
In the Formula Bar, delete one
character to the left. . . . . . . . . . . . . . . . . . . .[Backspace]
Complete a cell entry from the cell or
Formula Bar. . . . . . . . . . . . . . . . . . . . . . . . . . .[Enter]
Cancel an entry in the cell or
Formula Bar. . . . . . . . . . . . . . . . . . . . . . . . . . .[Esc]
In a formula, display the Insert
Function dialogue box. . . . . . . . . . . . . . . . .[Shift] + [F3]
When the insertion point is to the
right of a function name in a
formula, display the Function
Arguments dialogue box. . . . . . . . . . . . . . .[Ctrl] + [A]
When the insertion point is to the
right of a function name in a formula,
insert the argument names and
parentheses. . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [A]
Paste a defined name into a formula.
(Name: A word or string of characters
that represents a cell, range of cells,
formula, or constant value.
Use easy-to-understand names, such as
Products, to refer to hard to understand
ranges, such as Sales!C20:C30.) . . . .[F3]
Insert an AutoSum formula with the
SUM function. . . . . . . . . . . . . . . . . . . . . . . . .[Alt] + [=]
Copy the value from the cell above the
active cell into the cell or the Formula Bar. [Ctrl] + [Shift] + [“]
Copies a formula from the cell above the
active cell into the cell or the Formula Bar. [Ctrl] + [‘]
Alternate between displaying cell values
and displaying formulae. . . . . . . . . . . . . . . .[Ctrl] + [`]
Calculate all worksheets in all open
workbooks. When a portion of a formula
is selected, calculate the selected
portion. You can then press [Enter] or
[Ctrl] + [Shift] + [Enter] (for array
formulae) to replace the selected
portion with the calculated value. . . . . . .[F9]
Calculate the active worksheet. . . . . . . . . .[Shift] + [F9]
Calculate all worksheets in all open
workbooks, regardless of whether they
have changed since the last calculation. .[Ctrl] + [Alt] + [F9]
Rechecks dependent formulae and then
calculates all cells in all open
workbooks, including cells not marked
as needing to be calculated. . . . . . . . . . . . .[Ctrl] + [Alt] + [Shift] + [F9]
Edit the active cell and position the
insertion point at the end of the cell
contents. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[F2]
Start a new line in the same cell. . . . . . . .[Alt] + [Enter]
Edit the active cell and then clear it, or
delete the preceding character in the
active cell as you edit cell contents. . . . . .[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]
Display the Spelling dialogue box. . . . . . .[F7]
Edit a cell comment. . . . . . . . . . . . . . . . . . . .[Shift] + [F2]
Complete a cell entry and select the
next cell below. . . . . . . . . . . . . . . . . . . . . . . .[Enter]
Undo the last action. . . . . . . . . . . . . . . . . . .[Ctrl] + [Z]
Cancel a cell entry. . . . . . . . . . . . . . . . . . . . .[Esc]
When the AutoCorrect Smart Tags is
displayed, undo or redo the last
automatic correction. . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Z]
Copy the selected cells. . . . . . . . . . . . . . . . .[Ctrl] + [C]
Cut the selected cells. . . . . . . . . . . . . . . . . . .[Ctrl] + [X]
Paste copied cells. . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [V]
Clear the contents of the selected cells. . .[Delete]
Delete the selected cells. . . . . . . . . . . . . . . .[Ctrl] + [-]
Insert blank cells. . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] +

Display the Style dialogue box. . . . . . . . . .[Alt] + [‘]
Display the Format Cells dialogue box. . .[Ctrl] + [1]
Apply the General number format. . . . . . .[Ctrl] + [Shift] + [~]
Apply the Currency format with two
decimal places (negative numbers 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 AM or PM. . . . . . . . . . . . .[Ctrl] + [Shift] +

Apply the Number format with two
decimal places, thousands separator,
and minus sign (-) for negative values. . . .[Ctrl] + [Shift] + [!]
Apply or remove bold formatting. . . . . . . .[Ctrl] +
Apply or remove italic formatting. . . . . . .[Ctrl] +
Apply or remove underlining. . . . . . . . . . .[Ctrl] +
Apply or remove strikethrough. . . . . . . . . .[Ctrl] + [5]
Hide the selected rows. . . . . . . . . . . . . . . . .[Ctrl] + [9]
Hide the selected columns. . . . . . . . . . . . . .[Ctrl] +

Unhide any hidden rows within the
selection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [(]
Unhide any hidden columns within the
selection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [)]
Apply the outline border to selected cells. .[Ctrl] + [Shift] + [&]
Remove the outline border from the
selected cells. . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [_]
Apply or remove the top border. . . . . . . . .[Alt] + [T]
Apply or remove the bottom border. . . . . .[Alt] +
Apply or remove the left border. . . . . . . . .[Alt] + [L]
Apply or remove the right border. . . . . . . .[Alt] + [R]
If cells in multiple rows are selected,
apply or remove the horizontal divider. .[Alt] + [H]
If cells in multiple columns are selected,
apply or remove the vertical divider. . . . .[Alt] + [V]
Apply or remove the downward
diagonal border. . . . . . . . . . . . . . . . . . . . . . . .[Alt] + [D]
Apply or remove the upward
diagonal border. . . . . . . . . . . . . . . . . . . . . . . .[Alt] +

[bbasujon]

unction Key Shortcuts

Displays the Microsoft Office
Excel Help task pane. . . . . . . . . . . . . . . . . . .[F1]
Displays or hides the “Ribbon”. . . . . . . . . .[Ctrl] + [F1]
Creates a chart of the data in the
current range. . . . . . . . . . . . . . . . . . . . . . . . .[Alt] + [F1]
Inserts a new worksheet. . . . . . . . . . . . . . . .[Alt] + [Shift] + [F1]
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. . . . . . . . . . . .[F2]
Adds or edits a cell comment. . . . . . . . . . .[Shift] + [F2]
Displays the Print Preview window. . . . . .[Ctrl] + [F2]
Displays the Paste Name dialogue box. . .[F3]
Displays the Insert Function dialogue box. [Shift] + [F3]
Repeats the last command or action,
if possible. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[F4]
Closes the selected workbook window. . .[Ctrl] + [F4]
Displays the Go To dialogue box. . . . . . . . .[F5]
Restores the window size of the selected
workbook window. . . . . . . . . . . . . . . . . . . . .[Ctrl] + [F5]
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. . . . . . . . . . . . . . . . . . . . . . .[F6]
Switches between the worksheet, Zoom
controls, task pane, and Ribbon. . . . . . . . .[Shift] + [F6]
Switches to the next workbook window
when more than one workbook
window is open. . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [F6]
Displays the Spelling dialogue box to
check spelling in the active worksheet
or selected range. . . . . . . . . . . . . . . . . . . . . . .[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
ENTER, or ESC to cancel. . . . . . . . . . . . . . . .[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
ENTER, or ESC to cancel. . . . . . . . . . . . . . . .[F8]
Enables you to add a non-adjacent cell
or range to a selection of cells by using
the arrow keys. . . . . . . . . . . . . . . . . . . . . . . . .[Shift] + [F8]
Calculates all worksheets in all open
workbooks. . . . . . . . . . . . . . . . . . . . . . . . . . . .[F9]
Calculates the active worksheet. . . . . . . . .[Shift] + [F9]
Minimizes a workbook window to an icon. [Ctrl] + [F9]
Calculates all worksheets in all open
workbooks, regardless of whether they
have changed since the last calculation. .[Ctrl] + [Alt] + [F9]
Rechecks dependent formulas, and then
calculates all cells in all open
workbooks, including cells not marked
as needing to be calculated. . . . . . . . . . . . .[Ctrl] + [Shift] + [Alt] + [F9]
Turns key tips on or off. . . . . . . . . . . . . . . . .F10
Displays the shortcut menu for a
selected item. . . . . . . . . . . . . . . . . . . . . . . . . .[Shift] + [F10]
Maximizes or restores the selected
workbook window. . . . . . . . . . . . . . . . . . . . .[Ctrl] + [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. . . .[Alt] + [Shift] + [F10]
Creates a chart of the data in the
current range. . . . . . . . . . . . . . . . . . . . . . . . .[F11]
Inserts a new worksheet. . . . . . . . . . . . . . . .[Shift] + [F11]
Opens the Microsoft Visual Basic Editor,
in which you can create a macro by
using Visual Basic for Applications (VBA). .[Alt] + [F11]
Displays the Save As dialogue box. . . . . . .[F12]

[bbasujon]

Miscellaneous Shortcuts

Selects the tab to the left when the
Ribbon is selected. When a submenu
is open, closes the submenu. Otherwise,
if a menu is open, selects the next menu. .[Left Arrow]
Selects the tab to the right when the
Ribbon is selected. When a menu item
with a submenu is selected, opens the
submenu. Otherwise, if a menu is
open, selects the previous menu. . . . . . . .[Right Arrow]
Selects the next command when a
menu or submenu is open. When a
Ribbon tab is selected, navigates down
the tab group.In a dialogue box,
moves down the options in an open
drop-down list, or down the options in
a group of options. . . . . . . . . . . . . . . . . . . . .[Down Arrow]
Selects the previous command when a
menu or submenu is open. When a
Ribbon tab is selected, navigates up
the tab group.In a dialogue box, moves
up the options in an open drop-down
list, or up the options in a group of
options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Up Arrow]
Opens a selected drop-down list. . . . . . . . .[Down Arrow]
Opens a selected drop-down list. . . . . . . . .[Alt] + [Down Arrow]
Deletes one character to the left in the
Formula Bar.Also clears the content of
the active cell.In cell editing mode, it
deletes the character to the left of the
insertion point. . . . . . . . . . . . . . . . . . . . . . . .[Backspace]
Removes the cell contents (data and
formulas) from selected cells without
affecting cell formats or comments.
In cell editing mode, it deletes the
character to the right of the insertion
point. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Delete]
Moves to the cell in the lower-right
corner of the window when SCROLL
LOCK is turned on.Also selects the
last command on the menu when a
menu or submenu is visible. . . . . . . . . . . .[End]
Completes a cell entry and selects the
cell above. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Shift] + [Enter]
Starts a new line in the same cell. . . . . . . .[Alt] + [Enter]
Fills the selected cell range with the
current entry. . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Enter]
Cancels an entry in the cell or Formula
Bar.Closes an open menu or submenu,
dialogue box, or message window.
Closes full screen mode when this
mode has been applied, and returns
to normal screen mode to display the
Ribbon and status bar again. . . . . . . . . . . .[Esc]
Minimizes a workbook window to an icon. [Ctrl] + [F9]
Moves one screen down in a worksheet. .[Page Down]
Moves one screen to the right in a
worksheet. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Alt] + [Page Down]
Moves to the next sheet in a workbook. . .[Ctrl] + [Page Down]
Selects the current and next sheet in a
workbook. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Page Down]
Moves one screen up in a worksheet. . . . .[Page Up]
Moves one screen to the left in a worksheet.[Alt] + [Page Up]
Moves to the previous sheet in a workbook.[Ctrl] + [Page Up]
Selects the current and previous sheet
in a workbook. . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Page Up]
In a dialogue box, performs the action
for the selected button, or selects or
clears a check box. . . . . . . . . . . . . . . . . . . . .[Space]
Selects an entire column in a worksheet. [Ctrl] + [Space]
Selects an entire row in a worksheet. . . . .[Shift] + [Space]
Selects the entire worksheet.If the
worksheet contains data, selects the
current region.
Pressing [Ctrl] + [Shift] + SPACE a second
time selects the current region and its summary rows.
Pressing [Ctrl] + [Shift] + SPACE a
third time selects the entire worksheet.
When an object is selected, selects all
objects on a worksheet. . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Space]
Displays the Control menu for the
Microsoft Office Excel window. . . . . . . . . .[Alt] + [Space]
Switches to next tab in a dialogue box. . .[Ctrl] + [Tab]
Switches to previous tab in a dialogue box.[Ctrl] + [Shift] + [Tab]