Shortcut Keys

The workbook provides several shortcut keys. You can move the active cell, select cells using the mouse or keyboard, and use keyboard shortcuts to edit cell data.

note

When using the context menu, the workbook always performs an internal copy and paste because it cannot access the system clipboard.

Key	Action	Description
Alt + Enter	Insert new line	Adds a line in the cell (when you are in the formula bar).
Alt + F5	Switch formula reference	Toggles between relative, absolute, and mixed while editing a formula.
Alt + =	Insert SUM function	Inserts the SUM function and selects the previous cell automatically.
Alt + ;	Select visible cells	Selects only visible cells in the sheet.
Back	Clear and edit	Clears the active cell and enters edit mode.
Ctrl + A	Select all	Selects the entire sheet.
Ctrl + B	Bold	Applies bold formatting.
Ctrl + C	Copy	Copies the selection to the clipboard.
Ctrl + D	Copy from above	Copies the value from the cell above.
Ctrl + Down	Move to last row	Moves to the last row in the column.
Ctrl + End	Move to bottom-right	Moves to the last row and column.
Ctrl + Home	Move to first cell	Moves to the first cell in the sheet.
Ctrl + I	Italic	Applies italic formatting.
Ctrl + Left	Move to first column	Moves to the first column, ignoring frozen columns.
Ctrl + PageDown	Next sheet	Moves the active sheet to the next sheet.
Ctrl + PageUp	Previous sheet	Moves the active sheet to the previous sheet.
Ctrl + R	Copy from left	Copies the value from the cell to the left.
Ctrl + Right	Move to last column	Moves to the last column in the row.
Ctrl + Shift + Down	Extend to last row	Extends selection to the last row.
Ctrl + Shift + End	Extend to last cell	Extends selection to the bottom-right cell.
Ctrl + Shift + Home	Extend to first cell	Extends selection to the top-left cell.
Ctrl + Shift + Left	Extend to first column	Extends selection to the first column.
Ctrl + Shift + Right	Extend to last column	Extends selection to the last column.
Ctrl + Shift + Up	Extend to first row	Extends selection to the first row.
Ctrl + Shift + %	Apply percent format	Formats the number as a percentage.
Ctrl + Space	Select column	Extends the selection to include the current column.
Ctrl + U	Underline	Underlines the cell content.
Ctrl + Up	Move to first row	Moves to the first row in the column.
Ctrl + V	Paste	Pastes clipboard contents.
Ctrl + X	Cut	Cuts the selection to the clipboard.
Ctrl + Y	Redo	Redoes the last undone action.
Ctrl + Z	Undo	Undoes the last action.
Ctrl + -	Delete row or column	Deletes the selected row or column.
Ctrl + ;	Insert current date	Adds today’s date in the cell.
Ctrl + 9	Hide rows	Hides selected rows.
Delete	Clear	Clears the cell content.
Down	Move down	Moves to the next row.
End	Move to last column	Moves to the last column in the row.
Enter	Confirm and move down	Ends editing and moves to the next row.
ESC	Cancel input	Cancels the current entry.
F2	Edit mode	Enters edit mode.
Home	Move to first column	Moves to the first column in the row.
Left	Move left	Moves to the previous column.
PageDown	Page down	Moves down one screen.
PageUp	Page up	Moves up one screen.
Right	Move right	Moves to the next column.
Shift + Down	Extend selection down	Adds one row to the selection.
Shift + End	Extend to last column	Extends the selection to the last column.
Shift + Enter	Confirm and move up	Ends editing and moves to the previous row.
Shift + Home	Extend to first column	Extends the selection to the first column.
Shift + Left	Extend selection left	Adds one column to the selection.
Shift + PageDown	Extend page down	Extends selection one screen down.
Shift + PageUp	Extend page up	Extends selection one screen up.
Shift + Space	Select row	Selects the entire row.
Shift + Right	Extend selection right	Adds one column to the selection.
Shift + Tab	Move to previous cell	Moves to the previous cell.
Shift + Up	Extend selection up	Adds one row to the selection.
Tab	Move to next cell	Moves to the next cell.
Up	Move up	Moves to the previous row.