1. Navigating Excel with the Mouse
Basic Mouse Navigation
✔ Click – Select a cell.
✔ Double-click – Edit cell contents.
✔ Right-click – Open context menu (cut, copy, paste, formatting).
✔ Drag & Drop – Move or copy cells.
Scrolling with the Mouse
- Mouse Wheel → Scroll up/down.
- Shift + Mouse Wheel → Scroll left/right.
- Click + Drag Scrollbar → Fast vertical/horizontal movement.
Zooming with the Mouse
- Ctrl + Mouse Wheel → Zoom in/out.
- View → Zoom Slider (Bottom-right corner).
Essential Keyboard Shortcuts for Navigation
Basic Movement
| Shortcut | Action |
| Arrow Keys (↑ ↓ ← →) | Move one cell in any direction |
| Enter | Move down (Shift + Enter to move up) |
| Tab | Move right (Shift + Tab to move left) |
| Home | Go to the start of the row |
| Ctrl + Home | Jump to A1 (first cell) |
| Ctrl + End | Jump to the last used cell |
| Page Up / Page Down | Move one screen up/down |
| Alt + Page Up / Page Down | Move one screen left/right |
Fast Navigation
| Shortcut | Action |
| Ctrl + Arrow Key | Jump to the edge of data (last filled cell) |
| Ctrl + [ | Go to precedent cells (formula references) |
| Ctrl + ] | Go to dependent cells (cells using this formula) |
| F5 (Go To) | Jump to a specific cell (e.g., A50) |
| Ctrl + G | Same as F5 (Go To) |
| Ctrl + Backspace | Bring selected cell into view |
Using Scroll Features
Scroll Lock Mode (Rarely Used)
- Turn On/Off → Press Scroll Lock (ScrLk) key.
- When enabled:
- Arrow keys scroll the sheet instead of moving the active cell.
- Useful for viewing large datasets without losing selection.
Touchpad / Trackpad Scrolling
- Two-finger scroll → Vertical/horizontal movement.
- Ctrl + Two-finger scroll → Zoom in/out.
Custom Scroll Bars
- Right-click scrollbar → Adjust scrolling speed.
- Drag scrollbar → Fast navigation.