Select Active Cell Only in Excel (Ctrl + Shift + *)
This shortcut quickly selects only the active cell in a selected range, deselecting any other selected cells. It is helpful when you want to focus on a single cell for editing, formatting, or copying.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + * | Cmd + Shift + * |
What Does This Shortcut Do?
When multiple cells are selected, pressing this shortcut cancels all selections except the active cell, allowing you to work on it exclusively.
How to Use the Shortcut
- Select multiple cells or a range
- Press Ctrl + Shift + * (Windows) or Cmd + Shift + * (Mac)
- Only the active cell will remain selected
Tips & Best Practices
- Use when accidental multiple selections occur
- Combine with formatting or data entry on the active cell
- Works in ranges, tables, and filtered data
FAQ
- Q: Does this deselect non-contiguous cells?
- Yes, only the active cell remains selected, no matter the selection type.
- Q: Can I use it in filtered tables?
- Yes, it works in filtered and regular ranges.
- Q: Can I revert to the original selection?
- No, you would need to reselect manually or undo (Ctrl + Z / Cmd + Z).