🖥️ 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