Powerful and rare shortcuts Excel 365 version.
> Ctrl+ [ (left bracket) - Jump to “precedents” Selects all precedent cells (cells directly referenced by the active formula).
> Ctrl+ [ (left bracket) - Jump to “precedents”
Selects all precedent cells (cells directly referenced by the active formula).
Great for tracing logic and dependencies in complex models without using the Trace Precedents button.
Bonus: Ctrl + ] jumps to dependents.
> Ctrl+A+V - Open Data Validation in one shot
Instead of going Data > Data Validation via mouse, this opens the Data Validation dialog directly.
Very fast if you often set up input‑range lists or validation rules.
> Alt + A + Q - Open Advanced Filter directly
Bypasses the menu and opens the Advanced Filter dialog immediately.
Handy when you want to filter to another range or use a criteria table without formulas.
> Alt + W + G - Start Goal Seek without digging the ribbon
Opens Goal Seek (Data > What‑If Analysis > Goal Seek) in one keystroke.
Useful if you do trial‑and‑error reverse‑formula calculations a lot.
> Ctrl + / - Select the entire current array (dynamic spilled range)
When you’re inside a dynamic‑array result (e.g., FILTER, UNIQUE, SORT), this selects the whole spill range.
Helps you quickly copy, format, or delete the entire output block, not just the top‑left cell.
> Ctrl + Shift + 8 (or Ctrl + Shift + *) - Select the current region.
Selects the entire connected block of data around the active cell (like a table region, skipping blanks).
Often faster than dragging with the mouse when you have dense tables.
> Alt + H + F + D + S - Open “Go To Special: Styles”
Opens a rarely‑used but powerful Go To Special > Styles dialog, where you can jump to all cells with a specific style (e.g., “Bad”, “Good”, “Note”).
Very nice if you use custom cell styles for status‑coding sheets.
> F4 (repeat last action) - The secret macro‑like key
After you do something like formatting, resizing rows, or dragging a formula, hitting F4 repeats that exact action in the next cell/row.
It’s like a tiny built‑in macro recorder for one‑off actions.
> Alt + ; - Select only visible cells
When you have filtered or hidden rows, this selects only the visible cells, skipping the hidden ones.
Very useful for copying/pasting or deleting only the filtered data, or for referencing only visible values.
> Ctrl + “ (grave accent) - Show all formulas
Toggles between values and formulas for the entire sheet.
Great for auditing complex models or quickly seeing which cells contain formulas.
> Ctrl + Shift + L - Toggle AutoFilter
Instantly turns AutoFilter on or off for the selected range.
Handy when you work with dynamic tables and want to enable/disable filters with one keystroke.
