Select All Precedent Cells
Select all cells at any level that feed into the formula in the active cell.
Keyboard shortcut by app
| App | Windows | Mac |
|---|---|---|
| Microsoft 365 | ||
| Excel |
Ctrl+Shift+[ |
Ctrl+Shift+[ |
| Word | Not available | Not available |
| PowerPoint | Not available | Not available |
| Outlook | Not available | Not available |
| Teams | Not available | Not available |
| Google Workspace | ||
| Google Sheets | Not available | Not available |
| Google Docs | Not available | Not available |
| Google Slides | Not available | Not available |
Popular Functions
Hand-picked function guides that work in both Excel and Google Sheets.