Keyboard Shortcuts

  • 4 minutes to read

The Spreadsheet provides the capability to perform common commands quickly using keyboard shortcuts.

All supported shortcuts are divided into the following groups.

File Operations

Shortcut Description
CTRL+N Creates a blank workbook (supported only on the Internet Explorer and Microsoft Edge browsers).
CTRL+O Invokes the Open dialog box to open a new file (the Internet Explorer browser performs its native open action before a Spreadsheet's open action).
CTRL+S Saves changes in the current workbook.
CTRL+P Invokes the Print dialog box.
CTRL+F Invokes the Find and Replace dialog (with the Find tab activated).
SHIFT+F11 Inserts a new worksheet in front of the existing worksheet within the current workbook (not supported on the Safari browser).
Shortcut Description
LEFT ARROW KEY Moves the active cell one cell to the left in a worksheet.
RIGHT ARROW KEY Moves the active cell one cell to the right in a worksheet.
UP ARROW KEY Moves the active cell one cell up in a worksheet.
DOWN ARROW KEY Moves the active cell one cell down in a worksheet.
ENTER Moves the active cell one cell down in a worksheet.
SHIFT+ENTER Moves the active cell one cell up in a worksheet.
TAB Moves the active cell one cell to the right in a worksheet.
SHIFT+TAB Moves the active cell one cell to the left in a worksheet.

Work with Selection

Shortcut Description
ENTER Moves the active cell one cell down in the selection.
SHIFT+ENTER Moves the active cell one cell up in the selection.
TAB Moves the active cell one cell to the right in the selection.
SHIFT+TAB Moves the active cell one cell to the left in the selection.
CTRL+A Selects the entire worksheet or the data region to which the active cell belongs.
SHIFT+ARROW KEYS Extends the selection by one cell in the specified direction.

Cell Content Editing

Shortcut

Description

F2

Turns on the edit mode for the active cell and positions the cursor at the end of the cell's content.

SHIFT+LEFT ARROW KEY

In the cell edit mode, selects or deselects one character to the left.

SHIFT+RIGHT ARROW KEY

In the cell edit mode, selects or deselects one character to the right.

CTRL+SHIFT+LEFT ARROW KEY

In the cell edit mode, selects or deselects one word to the left.

CTRL+SHIFT+RIGHT ARROW KEY

In the cell edit mode, selects or deselects one word to the right.

SHIFT+HOME

In the cell edit mode, selects from the cursor current position to the beginning of the cell.

SHIFT+END

In the cell edit mode, selects from the cursor current position to the end of the cell.

ALT+ENTER

Starts a new line in the same cell.

ENTER

Completes a cell entry and selects the cell below.

SHIFT+ENTER

Completes a cell entry and selects the cell above.

TAB

Completes a cell entry and selects the cell to the right.

SHIFT+TAB

Completes a cell entry and selects the cell to the left.

ESC

Cancels an entry in a cell or Formula Bar.

BACKSPACE

In the cell edit mode, deletes a character to the left of the cursor.

DELETE

Removes the cell content without affecting the cell formatting.

In the cell edit mode, deletes a character to the right of the cursor.

CTRL+DELETE

In the cell edit mode, deletes all characters from the cursor's current position to the start of the next word.

CTRL+Z

Performs the Undo command to reverse the last action or to delete the last entry you typed.

Copy/Paste Operations

Shortcut Description
CTRL+V or SHIFT+INSERT Inserts the contents of the Clipboard in the specified cell and replaces any selection.
CTRL+X or SHIFT+DELETE Cuts the selected cells.
CTRL+D Performs the Fill Down command to copy the contents of the topmost cell to the active cell.
CTRL+R Performs the Fill Right command to copy the contents of the leftmost cell to the active cell.

Cell Formatting

Shortcut Description
CTRL+B or CTRL+2 Applies or removes bold formatting.
CTRL+I or CTRL+3 Applies or removes italic formatting.
CTRL+U or CTRL+4 Applies or removes underlining.
CTRL+5 Applies or removes strikethrough formatting.
CTRL+SHIFT+7 Applies the outline border to the selected cell or cell range.
CTRL+SHIFT+1 Applies the General number format with two decimal places.
CTRL+SHIFT+2 Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+3 Applies the Date format with the day, month and year.
CTRL+SHIFT+4 Applies the Currency format with two decimal places (negative numbers in parantheses).
CTRL+SHIFT+5 Applies the Percentage format with no decimal places.
CTRL+SHIFT+6 Applies the Scientific number format with two decimal places.