🖥️ 1. File Management (Save, Open, Print, Close)
- Ctrl + N → New Spreadsheet
- Ctrl + O → Open Spreadsheet
- Ctrl + S → Save Spreadsheet
- F12 → Save As
- Ctrl + P → Print
- Ctrl + W → Close Spreadsheet
- Ctrl + Q → Quit LibreOffice
⌨️ 2. Copy, Paste, Cut, Undo, Redo
- Ctrl + C → Copy
- Ctrl + X → Cut
- Ctrl + V → Paste
- Ctrl + Z → Undo
- Ctrl + Y → Redo
📌 Paste Special:
- Ctrl + Shift + V → Paste Special
📑 3. Selecting & Navigating Data
- Ctrl + A → Select All
- Ctrl + Home → Go to First Cell (A1)
- Ctrl + End → Go to Last Used Cell
- Ctrl + Arrow Keys → Move to Edge of Data
- Shift + Space → Select Entire Row
- Ctrl + Space → Select Entire Column
📌 Move Between Sheets:
- Ctrl + Page Up → Previous Sheet
- Ctrl + Page Down → Next Sheet
- Shift + F11 → Insert New Sheet
📊 4. Formatting Shortcut Keys
📌 Text Formatting:
- Ctrl + B → Bold
- Ctrl + I → Italic
- Ctrl + U → Underline
- Ctrl + 5 → Strikethrough
- Ctrl + Shift + P → Open Font Formatting
📌 Cell Formatting:
- Ctrl + 1 → Open Format Cells
- Ctrl + Shift + $ → Currency Format
- Ctrl + Shift + % → Percentage Format
- Ctrl + Shift + # → Date Format
- Ctrl + Shift + @ → Time Format
📌 Row & Column Management:
- Ctrl + “+” → Insert Row/Column
- Ctrl + “-“ → Delete Row/Column
- Alt + O + C + A → AutoFit Column Width
📈 5. Data Management & Analysis
📌 Sorting & Filtering:
- Ctrl + Shift + L → Apply/Remove AutoFilter
- Ctrl + Shift + Down Arrow → Select Column Data
- Alt + Down Arrow → Open Drop-down in Filter
📌 Find & Replace:
- Ctrl + F → Find
- Ctrl + H → Replace
📌 Formulas & Functions:
- F2 → Edit Formula in Cell
- Ctrl + ` → Show/Hide Formulas
- Ctrl + Shift + Enter → Enter Array Formula
- Alt + = → AutoSum
📌 Insert Charts & Functions:
- F11 → Insert Chart
- Ctrl + Shift + F3 → Define Name for Selection
🚀 6. Productivity Boosting Shortcuts
📌 Sheet Navigation & Special Commands:
- Ctrl + Page Up/Page Down → Move Between Sheets
- Ctrl + Shift + T → Restore Last Closed Tab
- Ctrl + T → Create a Table
📌 Zoom & View Settings:
- Ctrl + Mouse Scroll → Zoom In/Out
- Ctrl + Shift + J → Show/Hide Toolbar
- Ctrl + Shift + R → Refresh Display
📌 Repeat & Special Actions:
- F4 → Repeat Last Action
- Ctrl + Shift + ” (quote) → Copy Cell Above
- Ctrl + Shift + + → Insert New Row/Column
- Ctrl + Alt + V → Paste Special