Exceljet

Quick, clean, and to the point

Select active cell only

Windows shortcut 
ShiftBackspace
Mac shortcut 
⇧Delete

When multiple cells are selected, this shortcut will leave only the active cell selected.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.
How to chart generations with floating bars
In this video, we'll plot American generations in a chart with floating bars. This seems like a simple problem, but a solution takes a little creative thinking.
How to use VLOOKUP to merge tables
This video shows how to use VLOOKUP to merge data in two tables based on a common ID. You can even use this technique to reorder the columns you retrieve.
How to use the CHOOSE function
In this video, we'll look at how you can use the CHOOSE function. We also compare a formula based on CHOOSE vs. a formula based on VLOOKUP.
Shortcuts to move the active cell
In this lesson, we cover shortcuts you can use to move the active cell in a selection.