Skip to content

Keyboard Shortcuts

A complete reference of all keyboard shortcuts available in OpenSheets. You can also view this list inside the application by clicking the Keyboard Shortcuts button in the toolbar or pressing the help button.

Keyboard Shortcuts Panel

General

Shortcut Action
Ctrl+Z Undo
Ctrl+Y Redo
Ctrl+Shift+Z Redo (alternative)
Ctrl+S Save to URL / Share
Ctrl+F Find
Ctrl+H Find and Replace
Ctrl+A Select all
F1 Functions reference
Escape Cancel / Close
Shortcut Action
Arrow keys Move one cell in the arrow direction
Ctrl+Arrow Jump to the edge of the data region
Tab Move to the next cell (right)
Shift+Tab Move to the previous cell (left)
Enter Confirm input and move down
Shift+Enter Confirm input and move up
Home Go to column A in the current row
Ctrl+Home Go to cell A1
Ctrl+End Go to the last used cell
Page Down Scroll down one screen
Page Up Scroll up one screen

Selection

Shortcut Action
Shift+Arrow Extend selection by one cell
Ctrl+Shift+Arrow Extend selection to the edge of data
Ctrl+Space Select the entire column
Shift+Space Select the entire row
Ctrl+A Select all cells
Shift+Click Extend selection to the clicked cell
Ctrl+Click Add cell to selection

Editing

Shortcut Action
F2 Edit the active cell
Delete Clear cell contents
Backspace Clear contents and enter edit mode
Ctrl+C Copy
Ctrl+X Cut
Ctrl+V Paste
Alt+Enter Insert a new line in a cell (while editing)
Ctrl+; Insert the current date
Ctrl+Shift+; Insert the current time

Formatting

Shortcut Action
Ctrl+B Bold
Ctrl+I Italic
Ctrl+U Underline
Ctrl+5 Strikethrough
Ctrl+Shift+L Align left
Ctrl+Shift+E Align center
Ctrl+Shift+R Align right
Ctrl+Shift+1 Format as number
Ctrl+Shift+2 Format as time
Ctrl+Shift+3 Format as date
Ctrl+Shift+4 Format as currency
Ctrl+Shift+5 Format as percent
Ctrl+Shift+6 Format as scientific
Ctrl+\ Clear formatting

Rows and Columns

Shortcut Action
Ctrl+Shift+= Insert row or column
Ctrl+- Delete row or column
Right-click Open context menu with more options

Sheet Navigation

Shortcut Action
Alt+Shift+Right Move to the next sheet
Alt+Shift+Left Move to the previous sheet