📊 Excel Shortcuts — Part 2

This part focuses on Navigation & Selection shortcuts — especially useful when working with large datasets.

🟢 Navigation Shortcuts

1️⃣ Arrow Keys → Move one cell

2️⃣ Ctrl + Arrow Key → Jump to the edge of a data region

3️⃣ Home → Move to the beginning of the row

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

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

6️⃣ Page Up → Move one screen up

7️⃣ Page Down → Move one screen down

8️⃣ Alt + Page Up → Move one screen left

9️⃣ Alt + Page Down → Move one screen right

🔟 F5 → Open Go To 

🔵 Selection Shortcuts

1️⃣1️⃣ Shift + Arrow Key → Extend selection by one cell

1️⃣2️⃣ Ctrl + Shift + Arrow Key → Select data up to the edge of a data region

1️⃣3️⃣ Ctrl + Space → Select the entire column

1️⃣4️⃣ Shift + Space → Select the entire row

1️⃣5️⃣ Ctrl + A → Select the current data region / all data

1️⃣6️⃣ Ctrl + Shift + Space → Select the entire worksheet 

💡 Real-World Example

Imagine you have 50,000 rows of sales data.

Instead of scrolling manually:

Ctrl + ↓ → Jump to the bottom of the data

Ctrl + ↑ → Jump back to the top

Ctrl + Shift + ↓ → Select data down to the end

Ctrl + Space → Select the entire column

Shift + Space → Select the entire row 

🧠 Double Tap ❤️ For More