Tag: Excel vs LibreOffice Calc

  • LibreOffice Calc shortcut keys:

    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.