Keyboard Shortcuts

28 Feb 201718 minutes to read

Shortcut Description
Alt + Enter In Cell editing mode, starts a new line in the same cell
Alt + F1 Creates a

Chart

from the selected cells
Alt + T Opens create

Table

dialog box
Backspace Clears content of the active cell.
Deletes one character to the left in the Formula Bar.
In Cell editing mode, it deletes one character to the left of the insertion point.
Ctrl + \ To apply go to row difference for selected cells
Ctrl + 1 Opens

Format

cell dialog box
Ctrl + 5 Applies or removes strikethrough
Ctrl + 8 Hides the selected columns
Ctrl + 9 Hides the selected rows
Ctrl + A Selects the entire worksheet.If worksheet has data, Ctrl + A will selects current region. Pressing Ctrl + A second time selects the entire worksheet.
Ctrl + B Applies or removes bold formatting
Ctrl + C Copies the selected cells
Ctrl + D Uses the

Fill Down

command to copy the contents and format
Ctrl + F3 Opens name manager dialog box
Ctrl + I Applies or removes italic formatting
Ctrl + K Opens the

Insert Hyperlink

dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks
Ctrl + O Displays

Open

dialog box to open a file
Ctrl + P Opens

Print

dialog box
Ctrl + R Uses the

Fill Right

command to copy the contents and format
Ctrl + S Saves the current workbook
Ctrl + Space Bar Selects the entire column of selected cells in a worksheet
Ctrl + U Applies or removes underlining
Ctrl + Shift + & Applies the outline border to the selected cells
Ctrl + Shift + _ Removes the outline border from the selected cells
Ctrl + Shift + ~ Applies the General format
Ctrl + Shift + $ Applies the Currency format
Ctrl + Shift + % Applies the Percentage format
Ctrl + Shift + ^ Applies the Scientific format
Ctrl + Shift + # Applies the Short Date format
Ctrl + Shift + @ Applies the Time format
Ctrl + Shift + ! Applies the Number format with two decimal places
Ctrl + Shift + 8 To show hidden column within the selection
Ctrl + Shift + 9 To show hidden row within the selection
Ctrl + Shift + D Opens

Delete

dialog box
Ctrl + Shift + Home Extends the selection of cells to the beginning of the worksheet
Ctrl + Shift + I Opens

Insert

dialog box
Ctrl + Shift + F2 To expand or collapse ribbon content
Ctrl + Shift + O Highlight all cells that contain comments
Ctrl + Shift + | To apply go to column difference for selected cells
Ctrl + V Inserts the content of the clipboard based on active cell and replaces any selection. It can be performed after you have cut or copied cell contents.
Ctrl + X Cuts the selected cells
Ctrl + Y Repeats the last action, if possible
Ctrl + Z Reverses the last action or to delete the last entry
Delete Delete selected cells
Esc Cancel edit mode and discard changes.
F2 Start edit
Shift + F2 Adds or edits a cell comment
Shift + F11 Inserts a new worksheet
Shift + Spacebar Selects the entire row of selected cells in a worksheet