Sheets Shortcuts

All keyboards are equipped to perform shortcuts in Windows icon_Windows.png
Here’s a round-up of the ones you can use in OfficeSuite.

Keys Action
Ctrl+F4 Close Document
Ctrl+Shift+S Save As
F12 File Print Menu
Ctrl+P
Ctrl+F2
Alt+F File Menu
Ctrl+O Open
Ctrl+Z Undo

Ctrl+Y

F4

Redo
Repeat
Repeat Redo
Ctrl+N New
Ctrl+X Cut
Ctrl+V Paste
Ctrl+C Copy
Ctrl+S Save
Ctrl+F Find and Replace → Find tab
Shift+F5
Ctrl+H Find and Replace → Replace tab
Ctrl+B Bold
Ctrl+2
Ctrl+U Underline
Ctrl+4
Ctrl+I Italic
Ctrl+3
Ctrl+5 Strikethrough
Ctrl+G Go To
F5
Delete Clear Contents
F11 Insert Chart In New Sheet
Ctrl+9 Hide Rows
Ctrl+Shift+9 Unhide Rows
Ctrl+0 Hide Columns
Ctrl+Shift+0 Unhide Columns
Ctrl+Shift+7 Outside Borders
Ctrl+Shift+5 Percentage Formatting
Alt+F1 Insert Default Chart
Alt+Shift+F1 Insert Sheet
Shift+F11
F9 Recalculate
Ctrl+Alt+F9
Shift+F2 Insert/Edit Comment
Ctrl+K Insert Hyperlink
Ctrl+Shift+P Format Cells Dialog
Ctrl+1
Ctrl+Shift+F
Alt+Shift+Right Group Data
Alt+Shift+Left Ungroup Data
Up Move Selection Up
Shift+Enter Move Selection On Shift Enter Key
Down Move Selection Down
Alt+Down Open Dropdown
Left Move Selection Left
Right Move Selection Right
Page Up Move Selection Page Up
Page Down Move Selection Page Down
Alt+Page Up Move Selection Page Left
Alt+Page Down Move Selection Page Right
Ctrl+Page Up Previous Sheet
Ctrl+Page Down Next Sheet
Shift+Up Expand Selection Up
Shift+Down Expand Selection Down
Shift+Left Expand Selection Left
Shift+Right Expand Selection Right
Shift+Page Up Expand Selection Page Up
Shift+Page Down Expand Selection Page Down
Alt+Shift+Page Up Expand Selection Page Left
Alt+Shift+Page Down Expand Selection Page Right
Home Move Selection To Beginning Of Row
Shift+Home Expand Selection To Beginning Of Row
Ctrl+Home Move Selection to A1
Ctrl+Shift+Home Expand Selection to A1
Ctrl+End Move Selection to End of Sheet
Ctrl+Shift+End Expand Selection to End of Sheet
Ctrl+Space Select Entire Column
Shift+Space Select Entire Row
Ctrl+Shift+Space Select Entire Sheet
Ctrl+A
F2 Edit Cell Mode
Ctrl+Up Move Selection to Top Data
Ctrl+Shift+Up Expand Selection to Top Data
Ctrl+Down Move Selection to Bottom Data
Ctrl+Shift+Down Expand Selection to Bottom Data
Ctrl+Left Move Selection to Leftmost Data
Ctrl+Shift+Left Expand Selection to Leftmost Data
Ctrl+Right Move Selection to Rightmost Data
Ctrl+Shift+Right Expand Selection to Rightmost Data
Ctrl+T Insert Table
Ctrl+Oem1 Current Data Formula Box
Ctrl+Shift+Oem1 Current Time Formula Box
Ctrl+Shift+Oem3 General Format
Ctrl+Shift+OemMinus No Border
Ctrl+Shift+OemQuotes Copy Value From Cell Above
Ctrl+OemQuotes Copy Formula From Cell Above
Ctrl+Shift+1 Number Formatting with 2 Decimals Places
Ctrl+Shift+2 Default Time Format
Ctrl+Shift+3 Date Format DDMMYYYY
Ctrl+Shift+4 Default Currency Format
Ctrl+Shift+5 Default Percentage Format
Ctrl+Shift+6 Default Scientific Format
Ctrl+Shift+8 Select Cells with Data
Shift+F4 Find Next
Ctrl+Backspace Go to Selected Cell
Ctrl+Shift+L Filter

F4
(while referencing cells in inplace editor)

Switch between cell reference types

Was this article helpful?

1 out of 4 found this helpful