Keyboard shortcuts

The table below lists the keyboard shortcuts used when working with the application.

On laptops, some keys are multifunctional. For example, F1-F12, Home, End, PgUp (Page Up), PgDn (Page Down). When you press these keys in the MySpreadsheet application, it is necessary to hold Fn key down simultaneously.

tip

Some keyboard shortcuts or part of the shortcuts used in MySpreadsheet may also be used by the operating system. In this case, the shortcuts in the application will not work. To be able to use them, you should change the conflicting keyboard shortcuts in the operating system settings.

Keyboard shortcut		Description
Edit content
`Ctrl`+`X` `Shift`+`Delete`	`⌘Cmd`+`X`	Cut
`Ctrl`+`C` `Ctrl`+`Insert`	`⌘Cmd`+`C`	Copy
`Ctrl`+`V` `Shift`+`Insert`	`⌘Cmd`+`V`	Paste
`Ctrl`+`Alt`+`V`	`⌥Option`+`⌘Cmd`+`V`	Paste values and format
`Alt`+`Shift`+`V`	`⌥Option`+`⇧Shift`+`V`	Paste values only
`Ctrl`+`S`	`⌘Cmd`+`S`	Save
`F12` (Windows) `Ctrl`+`Shift`+`S` (Linux)	`⇧Shift`+`⌘Cmd`+`S`	Save as
`Ctrl`+`Z` `Alt`+`Backspace`	`⌘Cmd`+`Z`	Undo the last action
`Ctrl`+`Y` `Ctrl`+`Shift`+`Z` `Shift`+`Alt`+`Backspace`	`⌘Cmd`+`Y`	Redo the result of the undone action
`Ctrl`+`Alt`+`Shift`+`V` (Windows) `Win`+`V` (Linux)	`⌥Option`+`⇧Shift`+`⌘Cmd`+`V`	Open the clipboard history
Format content
`Ctrl`+`B`	`⌘Cmd`+`B`	Bold
`Ctrl`+`I`	`⌘Cmd`+`I`	Italic
`Ctrl`+`U`	`⌘Cmd`+`U`	Underline
`Ctrl`+`Shift`+`=`	`⇧Shift`+`⌘Cmd`+`=`	Superscript
`Ctrl`+`=`	`⌘Cmd`+`=`	Subscript
`Ctrl`+`Shift`+`A`	`⇧Shift`+`⌘Cmd`+`A`	All caps
`Ctrl`+`Shift`+`C`	`⇧Shift`+`⌘Cmd`+`C`	Copy formatting
`Ctrl`+`Shift`+`V`	`⇧Shift`+`⌘Cmd`+`V`	Apply formatting
`Ctrl`+`L`	`⌘Cmd`+`L`	Align the cell content to the left
`Ctrl`+`E`	`⌘Cmd`+`E`	Center the cell content
`Ctrl`+`R`	`⌘Cmd`+`R`	Align the cell content to the right
`Ctrl`+`J`	`⌘Cmd`+`J`	Justify the cell content
`Ctrl`+`1`	`⌘Cmd`+`1`	Open number format settings window
Move within the workspace
`Page Up`	`Fn`+`↑`	Move one screen up
`Page Down`	`Fn`+`↓`	Move one screen down
`Ctrl`+`Home`	`Fn`+`⌘Cmd`+`←`	Go to the first cell in the workspace (A1 cell)
`Ctrl`+`End`	`Fn`+`⌘Cmd`+`→`	Go to the last cell in the workspace
`Ctrl`+`↑` `Ctrl`+`↓` `Ctrl`+`←` `Ctrl`+`→`	`⌘Cmd`+`↑` `⌘Cmd`+`↓` `⌘Cmd`+`←` `⌘Cmd`+`→`	Move to the edge cell of the current data area, or to the edge cell of the nearest data area if the edge cell of the region or an empty cell is selected
Move between sheets and select sheets
`Ctrl`+`Page Up`	`⌃Ctrl`+`Fn`+`↑` `⌘Cmd`+`Fn`+`↑`	Go to the next sheet (to the right of the current one in the sheet tab pane)
`Ctrl`+`Page Down`	`⌃Ctrl`+`Fn`+`↓` `⌘Cmd`+`Fn`+`↓`	Go to the previous sheet (to the left of the current sheet in the sheet tab pane)
`Ctrl`+`Shift`+`Page Up`	`⌃Ctrl`+`Fn`+`Shift`+`↑` `⌘Cmd`+`Fn`+`Shift`+`↑`	Go to the last sheet (rightmost on the sheet tab pane)
`Ctrl`+`Shift`+`Page Down`	`⌃Ctrl`+`Fn`+`Shift`+`↓` `⌘Cmd`+`Fn`+`Shift`+`↓`	Go to the first sheet (leftmost on the sheet tab pane)
`Ctrl`+Left mouse button	`⌘Cmd`+Left mouse button	Select individual sheets
`Shift`+Left mouse button	`⇧Shift`+Left mouse button	Select adjacent sheets
Cells, columns, and rows
`F2`	`Fn`+`F2`	Switch to cell editing mode
`Alt`+`A`	`⌥Option`+`A`	Insert a row above
`Alt`+`B`	`⌥Option`+`B`	Insert a row below
`Alt`+`L`	`⌥Option`+`L`	Insert a column to the left
`Alt`+`R`	`⌥Option`+`R`	Insert a column to the right
`Ctrl`+`Alt`+`M`	`⌥Option`+`⌘Cmd`+`M`	Merge cells
`Alt`+`Shift`+`M`	`⌥Option`+`⇧Shift`+`M`	Split cells
`Ctrl`+`—`	`⌘Cmd`+`—`	Delete a row or column
`Ctrl`+`9`	`⌘Cmd`+`(`	Hide selected rows
`Ctrl`+`Shift`+`9`	`⌘Cmd`+`⇧Shift`+`(`	Show hidden rows
`Ctrl`+`0`	`⌘Cmd`+`)`	Hide selected columns
`Ctrl`+`Shift`+`0`	`⌘Cmd`+`⇧Shift`+`)`	Show hidden columns
`Alt`+`Shift`+`→`	`⌥Option`+`⇧Shift`+`→`	Group rows or columns
`Alt`+`Shift`+`←`	`⌥Option`+`⇧Shift`+`←`	Ungroup rows or columns
`Ctrl`+`Shift`+`L`	`⌘Cmd`+`⇧Shift`+`L`	Enable or disable sorting and filtering for the selected range
Select cells, columns, and rows
`↑`	`↑`	Select a cell above
`↓`	`↓`	Select a cell below
`Tab` or `→`	`⇥Tab` or `→`	Select the next cell
`←`	`←`	Select the previous cell
`Home`	`Fn`+`←`	Select the cell in the beginning of the row
`End`	`Fn`+`→`	Select the cell at the end of the row
`Shift`+`Space`	`Shift`+`Space`	Select a row
`Ctrl`+`Space`	`⇧Shift`+`⌘Cmd`+`Space`	Select a column
`Ctrl`+`Shift`+`Home`	`⇧Shift`+`Fn`+`⌘Cmd`+`←`	Create a selection area from the selected cell to the first cell in the workspace (A1 cell)
`Ctrl`+`Shift`+`End`	`⇧Shift`+`Fn`+`⌘Cmd`+`→`	Select an area from the selected cell to the last cell in the workspace
`Ctrl`+`Shift`+`↑`	`⇧Shift`+`⌘Cmd`+`↑`	Select an area from the selected cell to the first cell in the column
`Ctrl`+`Shift`+`↓`	`⇧Shift`+`⌘Cmd`+`↓`	Select an area from the selected cell to the last cell of the column in the workspace
`Ctrl`+`Shift`+`←`	`⇧Shift`+`⌘Cmd`+`←`	Select an area from the selected cell to the first cell in the row
`Ctrl`+`Shift`+`→`	`⇧Shift`+`⌘Cmd`+`→`	Select an area from the selected cell to the last cell of the row in the workspace
`Ctrl`+`A`	`⌘Cmd`+`A`	Select all cells of workspace on the sheet
`Ctrl`+Left mouse button	`⌘Cmd`+Left mouse button	Multiple selection
`Shift`+`↑`	`⇧Shift`+`↑`	Expand the selection by one cell upwards
`Shift`+`↓`	`⇧Shift`+`↓`	Expand the selection by one cell downwards
`Shift`+`←`	`⇧Shift`+`←`	Extend selection one cell to the left in the table
`Shift`+`→`	`⇧Shift`+`→`	Extend selection one cell to the right in the table
`Shift`+`Page Up`	`⇧Shift`+`Fn`+`↑`	Expand the selection one screen up
`Shift`+`Page Down`	`⇧Shift`+`Fn`+`↓`	Expand the selection one screen down
`Tab`	`⇥Tab`	Move the active cell cursor to the right
`Shift`+`Tab`	`⇧Shift`+`⇥Tab`	Move the active cell cursor to the left
`Enter`	`⌤Enter`	Move the active cell cursor down
`Shift`+`Enter`	`⇧Shift`+`⌤Enter`	Move the active cell cursor up
`F8`	`Fn`+`F8`	Enable the Extended selection between cells mode
`Shift`+`F8`	`Fn`+`⇧Shift`+`F8`	Enable the Multiple range selection mode
Actions with cell content*
`Backspace`	`Delete`	Delete one character to the left of the cursor
`Delete`	`Fn`+`Delete`	Delete one character to the right of the cursor
`Ctrl`+`Backspace`	`⌘Cmd`+`Delete` `⌥Option`+`Delete`	Delete part of a word or the entire word to the left of the cursor
`Ctrl`+`Delete`	`⌘Cmd`+`Fn`+`Delete` `⌥Option`+`Fn`+`Delete`	Delete part of a word or the entire word to the right of the cursor
`Alt`+`Enter`	`⌥Option`+`⌤Enter`	Start a new paragraph (used only for text values, ignored when working with formulas)
`Ctrl`+`Shift`+`Space`	`⌥Option`+`⇧Shift`+`Space`	Insert a non‑breaking space
`Ctrl`+`Shift`+`–`	`⌘Cmd`+`⇧Shift`+`–`	Insert a non‑breaking hyphen
`Ctrl`+`Num –`	`⌥Option`+`–`	Insert an en dash
`Ctrl`+`Alt`+`Num –`	`⌥Option`+`⇧Shift`+`–`	Insert an em dash
`F4`	`F4`	Change the type of reference in a formula or function
Double-click the cell. Select the cell and start typing. Go to the Formula bar. Press F2 (Windows, Linux) or Fn+F2 (macOS).
Select text in the active cell*
`Shift`+`←`	`⇧Shift`+`←`	Select one character to the left of the cursor
`Shift`+`→`	`⇧Shift`+`→`	Select one character to the right of the cursor
`Ctrl`+`Shift`+`←`	`⇧Shift`+`⌘Cmd`+`←`	Select one word to the left of the cursor
`Ctrl`+`Shift`+`→`	`⇧Shift`+`⌘Cmd`+`→`	Select one word to the right of the cursor
`Shift`+`Home`	`Fn`+`⇧Shift`+`←`	Select the content from the cursor to the beginning of the line
`Shift`+`End`	`Fn`+`⇧Shift`+`→`	Select the content from the cursor to the end of the line
`Ctrl`+`Shift`+`↑`	`⇧Shift`+`⌃Ctrl`+`⌘Cmd`+`↑`	Select or deselect before the beginning of the paragraph
`Ctrl`+`Shift`+`↓`	`⇧Shift`+`⌃Ctrl`+`⌘Cmd`+`↓`	Add selection to end of paragraph
`Shift`+`↑`	`⇧Shift`+`↑`	Select or deselect one row of text above
`Shift`+`↓`	`⇧Shift`+`↓`	Select or deselect one row of text below
`Shift`+`←`	`⇧Shift`+`←`	Select or deselect one position to the left of the cursor
`Shift`+`→`	`⇧Shift`+`→`	Select or deselect one position to the right of the cursor
Left double-click		Select a word
Left triple-click		Select a paragraph
Left-click and move the cursor up		Select the text located above the cursor
Left-click and move the cursor down		Select the text located below the cursor
Double-click the cell. Select the cell and start typing. Go to the Formula bar. Press F2 (Windows, Linux) or Fn+F2 (macOS).
Move within text in the active cell*
`←`	`←`	Move one character to the left
`→`	`→`	Move one character to the right
`Ctrl`+`←`	`⌘Cmd`+`←`	Move one word to the left
`Ctrl`+`→`	`⌘Cmd`+`→`	Move one word to the right
`↑`	`↑`	Move one line up
`↓`	`↓`	Move one line down
`Ctrl`+`↑`	`⌘Cmd`+`↑`	Move to the beginning of the previous paragraph
`Ctrl`+`↓`	`⌘Cmd`+`↓`	Move to the beginning of the next paragraph
Double-click the cell. Select the cell and start typing. Go to the Formula bar. Press F2 (Windows, Linux) or Fn+F2 (macOS).
Work with formulas and functions
`Alt`+`F9`	`⌥Option`+`F9`	Replace part of the formula or the entire formula with its calculated value
`Alt`+`=`	`⌥Option`+`=`	Quick insertion of the SUM function with automatic determination of arguments
`F9`	`F9`	Recalculate formulas in the entire document
`Shift`+`F9`	`⇧Shift`+`F9`	Recalculate formulas on the sheet
`Ctrl`+`Shift`+`F9`	`⇧Shift`+`⌘Cmd`+`F9`	Force calculate formulas
`Ctrl`+`Shift`+`F5`	`⇧Shift`+`⌘Cmd`+`F5`	Update references to data in external documents
`Ctrl`+`Shift`+`Enter`	`⇧Shift`+`⌘Cmd`+`⌤Enter`	Use formula as array formula
Other keyboard shortcuts
`Ctrl`+`N`	`⌘Cmd`+`N`	New file
`Ctrl`+`O`	`⌘Cmd`+`O`	Open a file
`Ctrl`+`Shift`+`O`	`⇧Shift`+`⌘Cmd`+`O`	Open a file in the cloud
`Ctrl`+`P`	`⌘Cmd`+`P`	Open the preview and print settings window
`Ctrl`+`K`	`⌘Cmd`+`K`	Insert a link (to a web page or email address, to a place in a document, or to a file)
`Ctrl`+`Shift`+`V`	`⇧Shift`+`⌘Cmd`+`V`	Insert a link from the clipboard
`Ctrl`+`Shift`+`1`	`⇧Shift`+`⌘Cmd`+`1`	Split the number into digit groups
`Ctrl`+`F` `Ctrl`+`H`	`⌘Cmd`+`F`	Open the Find and replace pane
`Ctrl`+`T`	`⌘Cmd`+`T`	Open the window to create a table
`Shift`+`F3`	`⇧Shift`+`F3`	Open the function pane
`Ctrl`+`Shift`+`U`	`⌘Cmd`+`⇧Shift`+`U`	Collapse or expand the Formula bar
`Ctrl`+`/`	`⌘Cmd`+`/`	Open the Quick actions pane
`F1`	`Fn`+`F1`	Open the Help section
Right-click	Right-click	Open the context menu of the selected element
`Alt`+`Space`	–	Open the context menu of the active window of the application
`Alt`+`F4`	`⌘Cmd`+`Q`	Close the active window of the application