📊 Excel Shortcuts — Part 6

This part focuses on Worksheet & Sheet Management shortcuts — useful when working with multiple sheets and large workbooks.

🟢 Worksheet Navigation

1️⃣ Ctrl + Page Up → Move to the previous worksheet

2️⃣ Ctrl + Page Down → Move to the next worksheet

3️⃣ Ctrl + Home → Go to the beginning of the active worksheet

4️⃣ Ctrl + End → Go to the last used cell

🔵 Working With Sheets

5️⃣ Shift + F11 → Insert a new worksheet

6️⃣ Alt + O + H + R → Rename the active worksheet

7️⃣ Alt + O + H + D → Delete the active worksheet

8️⃣ Alt + O + H + U → Unhide a worksheet

9️⃣ Alt + O + H + H → Hide the active worksheet

🟣 Moving & Copying Sheets

🔟 Alt + O + H + M → Move or copy a worksheet

1️⃣1️⃣ Ctrl + Page Up → Navigate to the previous sheet

1️⃣2️⃣ Ctrl + Page Down → Navigate to the next sheet

🟠 Workbook Navigation

1️⃣3️⃣ Ctrl + Tab → Switch between open workbooks/windows

1️⃣4️⃣ Ctrl + F6 → Switch between workbook windows

1️⃣5️⃣ Alt + Tab → Switch between open applications

💡 Real-World Example

Imagine your workbook contains:

📄 Sales

📄 Customers

📄 Products

📄 Dashboard

📄 Raw Data

Instead of clicking each sheet with your mouse:

➡️ Ctrl + Page Down → Move to the next sheet

➡️ Ctrl + Page Up → Move back

➡️ Shift + F11 → Create a new sheet

➡️ Rename the sheet using the keyboard

➡️ Hide unnecessary sheets when preparing a report

🔥 Double Tap ❤️ For More