FILE MENU

CTRL + N – New Sheet

CTRL + Shift + N – Manage Templates

CTRL + O – To open Previous Saved File

Shift + F11 – To save a Template

CTRL + S – To save a file

CTRL + Shift + S– Save As

CTRL + Enter – Next Line

CTRL + Shift + O – Print Preview

CTRL + Q – Exit Libreoffice

EDIT MENU

CTRL + X – cut

CTRL + C – Copy

CTRL + V – Paste

CTRL + Z – Undo

CTRL + Y – Redo

CTRL + Shift + Y – Repeat

 CTRL + Shift + V – Paste Special

CTRL + Alt + Shift + V – Paste Unformatted Text

CTRL + Shift + Spacebar – Select All

CTRL + PageDn  / CTRL + Tab – Go To Next Sheet

CTRL + PageUp  / CTRL + Shift + Tab – Go To Previous Sheet

Shift + Spacebar – Select Row

CTRL + Spacebar – Select Column

CTRL + * – Select Data Area

F2  – Edit Cell

CTRL + Shift + M – Edit Mode

CTRL + H – Find and Replace

CTRL + F – Find

VIEW MENU

CTRL + F8 – Value Highlighting

CTRL – Show Formula

CTRL + F5 – Show / Hide Sidebar

F11 – Show / Hide Styles

F5 – Open Navigator

CTRL + Shift + J – Full Screen

CTRL + Shift + F4 – Data Source Hide/Show

INSERT MENU

CTRL + F2 – Insert Function

CTRL + Alt + C – Comments

CTRL + K – Hyperlink

CTRL + ; – Date

CTRL + Shift + ; – Time

FORMAT MENU

CTRL + B – Bold

CTRL + I – Italic

CTRL + U – Underline

CTRL + Shift +P – Superscript

CTRL + Shift + B – Subscript

Shift + F3 – Cycle case

CTRL + 5 – 1.5 Line Spacing

CTRL + 2 – 2 Line Spacing

CTRL + L – Left Alignment

CTRL + E – Centre Alignment

CTRL + L – Left Alignment

CTRL + J – Justified Alignment

CTRL + ] – Increase Size

CTRL – [ – Decrease

CTRL + D – Double Under Line

CTRL + Shift + 6 – General Format

CTRL + Shift + 1 – Number Format

CTRL + Shift + 5 – Percent Format

CTRL + Shift + 4 – Currency Format

CTRL + Shift + 3 – Date Format

CTRL + Shift + 2 – Scientific

CTRL + M – Clear Formatting

CTRL + 1 – Cell Formatting

STYLE MENU

F11 – Manage Styles

SHEET MENU

CTRL + + – Insert cell

CTRL + – – Delete cell

Backspace –  Clear Cells

F4 – Cycle Cell Reference Type

CTRL + D – Fill Down

CTRL + ALT + C – Edit Comment

CTRL + Shift + Tab – To Previous Sheet

CTRL + Tab – To Next Sheet

CTRL + F3 – Manage Names

Tab – Go To Next Cell

 Shift + Tab – Go To Previous Cell

DATA MENU

CTRL + Shift + F9 – Recalculate Hard

F9 – Recalculate

F12 – Group

CTRL + F12 –  Ungroup

TOOLS MENU

F7 – Spelling

Shift + F7 – Automatic Spelling Check

CTRL + F7 – Thesaurus

Shift + F9 – Trace Precedents

Shift + F5 – Trace Dependents

CTRL + ALT + E – Extension Manager

WINDOW MENU

CTRL + W – Close Window

HELP MENU

F1 – Help