Spreadsheet Keyboard Shortcuts
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
GroupFunctionUNO CommandCalcExcelQuattro ProGoogle DocsiWork NumbersExcel for MacGnumericCalligra SheetWPS/Kingsoft Spreadsheet
2
Sheet Management & Navigation
3
Insert Sheet.uno:InsertNone
Alt + Shift + F1 / Shift + F11
NoneShift + F11NoneNone
4
Previous Sheet.uno:JumpToPrevTableCtrl + PgUpCtrl + PgUpCtrl + PgUpCmd + PgUpCtrl + PgUp
5
Next Sheet.uno:JumpToNextTableCtrl + PgDnCtrl + PgDnCtrl + PgDnCmd + PgDnCtrl + PgDn
6
Sheet PropertiesCtrl + F12
7
Spreadsheet PropertiesNoneShift + F12
8
9
Cell Managment & Navigation
10
Hide Rows.uno:HideRowNoneCTRL+9NoneCtrl + 9None
11
Unhide Rows.uno:ShowRowNoneCTRL+SHIFT+( (9)NoneCtrl + (None
12
Hide Columns.uno:HideColumnNoneCTRL+0NoneCtrl + 0None
13
Unhide Columns.uno:ShowColumnNoneCTRL+SHIFT+) (0)NoneCtrl + )None
14
Insert cell dialog.uno:InsertCellCtrl + Plus (+)CTRL+SHIFT+Plus (+)NoneCtrl + Plus (+)None
15
Remove cell dialog.uno:DeleteCellCtrl + Minus (-)CTRL+Minus (-)NoneCtrl + Minus (-)None
16
17
Select
18
All Sheets.uno:TableSelectAllNone
19
Previous Sheet / Next Sheet.uno:JumpToPrevTableSel / .uno:JumpToNextTableSel
Ctrl + Shift + PgUp or PgDn
Ctrl + Shift + PgUp or PgDn
Ctrl + Shift + PgUp or PgDn
20
Sheet.uno:SelectAllCtrl + A
CTRL+A / CTRL+SHIFT+SPACEBAR
None
Ctrl + A / Ctrl + Shift + Space
Ctrl + Shift + Space
21
Column.uno:SelectColumnCtrl + Shift + SpaceCTRL+SPACEBARNoneCtrl + SpaceCtrl + Space
22
Row.uno:SelectRowShift + SpaceSHIFT+SPACEBARNoneShift + SpaceShift + Space
23
Data Area.uno:SelectDataCtrl + *CTRL+SHIFT+*
24
All Cells with CommentsCTRL+SHIFT+O
25
26
Formatting
27
Format dialog.uno:FormatCellDialogCtrl + 1CTRL+1F12Ctrl + 1Ctrl + Alt + F
28
Bold.uno:BoldCtrl + BCTRL+2 / CTRL+BCtrl+BCtrl + BCmd + B
29
Italicsuno:ItalicCtrl + ICTRL+3 / CTRL+ICtrl+ICtrl + ICmd + I
30
Underline.uno:UnderlineCtrl + UCTRL+4 / CTRL+UCtrl+UCtrl + UCmd + U
31
Strikethrough.uno:StrikeoutNoneCTRL+5Alt + Shift + 5
32
Superscript.uno:SuperScriptCtrl + Shift + PCmd + Ctrl + Plus (+)Ctrl + ^ (Shift + 6)
33
Subscript.uno:SubScriptCtrl + Shift + BCmd + Ctrl + Minus (-)Ctrl + _ (Shift + Minus)
34
Align Left.uno:CommonAlignLeftCtrl + LCtrl+LCtrl + Shift + LCmd + }
35
Align Center
.uno:CommonAlignHorizontalCenter
Ctrl + ECtrl+ECtrl + Shift + ECmd + |
36
Align Right.uno:CommonAlignRightCtrl + RCtrl+RCtrl + Shift + RCmd + {
37
38
Number Formats
39
General
.uno:NumberFormatStandard
Ctrl + Shift + 6CTRL+SHIFT+~ (`)
40
Number.uno:NumberFormatDecimalCtrl + Shift + 1CTRL+SHIFT+! (1)
41
Time.uno:NumberFormatTimeNoneCTRL+SHIFT+@ (2)
42
Date.uno:NumberFormatDateCtrl + Shift + 3CTRL+SHIFT+# (3)
43
Currency
.uno:NumberFormatCurrency
Ctrl + Shift + 4CTRL+SHIFT+$ (4)
44
Percentage.uno:NumberFormatPercentCtrl + Shift + 5CTRL+SHIFT+% (5)
45
Scientific
.uno:NumberFormatScientific
Ctrl + Shift + 2CTRL+SHIFT+^ (6)
46
47
Insert
48
Time.uno:InsertCurrentTimeCtrl + Shift + ;CTRL+SHIFT+:Ctrl + Shift + ;
49
Dateuno:InsertCurrentDateCtrl + ;CTRL+;Ctrl + DCtrl + ;
50
Fill Down / Range.uno:FillDownCtrl + DCTRL+D / CTRL+ENTERCtrl + D / Ctrl + Enter
51
Fill Right.uno:FillRightCTRL+RCtrl + R
52
Page Break (hard)Ctrl + Enter
53
Chart.uno:InsertObjectChartNoneALT+F1
54
Chart in New SheetF11
55
Comment.uno:InsertAnnotationCtrl + Alt + CSHIFT+F2Ctrl + Alt + M
56
Named Range.uno:InsertNameNoneF3
57
58
View
59
Toggle between cell value and formula
.uno:ToggleFormulaNoneCTRL+`Ctrl + ~ (`)
60
Toggle between cell references.uno:ToggleRelativeF4F4F4
61
Expand / Contract formula fieldCTRL+SHIFT+U
62
ToolbarCTRL+F1
63
Print PreviewCtrl + Shift + OCTRL+F2
64
65
Dialogs
66
Function.uno:FunctionDialogCtrl + F2SHIFT+F3Alt + F3
67
Find & Replace > FindCtrl + FCTRL+F / SHIFT+F5Ctrl + FCtrl + F
68
Find & Replace > ReplaceCtrl + HCTRL+HCtrl + HCtrl + H
69
Format Cells > FontNone
CTRL+SHIFT+F / CTRL+SHIFT+P
70
Go ToNoneCTRL+G / F5CTRL+G / F5
71
HyperlinkCtrl + KCTRL+KCtrl + K
72
PrintCtrl + PCTRL+PCtrl+P
73
Create TableNoneCTRL+T / CTRL+LNone
74
Page Setup
75
SymbolCtrl + W
76
77
File Management
78
New.uno:AddDirectCtrl + NCTRL+NCtrl+N
79
Open.uno:OpenFromCalcCtrl + OCTRL+OCtrl+O
80
Save.uno:SaveCtrl + SCTRL+SCtrl+S
81
Save As.uno:SaveAsCtrl + Shift + SF12F3
82
Close.uno:CloseDocCtrl + F4CTRL+F4Ctrl+F4
83
84
Styles
85
Table/Cell AutoFormatCtrl + Shift + F
86
Styles Listbox/ComboboxCtrl + Shift + S
87
88
Tools
89
Spellcheck.uno:SpellDialogF7F7Ctrl + F1None
90
Start VBA Editor.uno:BasicIDEAppearNoneALT+F11Alt + F11
91
Settings / Preferences.uno:OptionsTreeDialogNoneAlt + F12
92
93
Borders
94
Apply outline borderCTRL+SHIFT+& (7)Alt + Shift + 7
95
Remove outline borderCTRL+SHIFT+_ (Minus)Alt + Shift + 6
96
Apply top borderAlt + Shift + 1
97
Apply right borderAlt + Shift + 2
98
Apply bottom borderAlt + Shift + 3
99
Apply left borderAlt + Shift + 4
100
Loading...
Main menu