LibreOffice Calc shortcut keys:

General Shortcuts

ActionShortcut Key
New FileCtrl + N
Open FileCtrl + O
Save FileCtrl + S
PrintCtrl + P
UndoCtrl + Z
RedoCtrl + Y
CutCtrl + X
CopyCtrl + C
PasteCtrl + V
Select AllCtrl + A
FindCtrl + F
Find & ReplaceCtrl + H
Insert FunctionShift + F2
Spell CheckF7

Navigation Shortcuts

ActionShortcut Key
Move to the Next Cell (Right)Tab
Move to the Previous Cell (Left)Shift + Tab
Move to the Next Row (Down)Arrow Down
Move to the Previous Row (Up)Arrow Up
Go to the First Cell (A1)Ctrl + Home
Go to the Last CellCtrl + End
Go to the Next SheetCtrl + Page Down
Go to the Previous SheetCtrl + Page Up

Editing Shortcuts

ActionShortcut Key
Insert RowCtrl + Shift + +
Delete RowCtrl + -
Insert ColumnCtrl + Shift + =
Delete ColumnCtrl + Shift + -
Add a New SheetShift + F11
Insert HyperlinkCtrl + K
Open Cell Format DialogCtrl + 1

Formatting Shortcuts

ActionShortcut Key
BoldCtrl + B
ItalicCtrl + I
UnderlineCtrl + U
Align LeftCtrl + L
Align CenterCtrl + E
Align RightCtrl + R
Increase Font SizeCtrl + Shift + >
Decrease Font SizeCtrl + Shift + <
Format as CurrencyCtrl + Shift + $
Format as PercentageCtrl + Shift + %

Cell Formatting Shortcuts

ActionShortcut Key
Format as DateCtrl + Shift + #
Format as NumberCtrl + Shift + !
Format as TextCtrl + Shift + @
Merge CellsCtrl + M
Wrap Text in CellAlt + Enter

Data Shortcuts

ActionShortcut Key
AutoSumAlt + Shift + =
Sort AscendingAlt + A + S
Sort DescendingAlt + A + O
Open Filter MenuCtrl + Shift + L
Toggle Auto FilterCtrl + Shift + L

These shortcuts will help improve your efficiency while using LibreOffice Calc.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *