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

Tip: How to use the CHOOSE function
How to use the CHOOSE function
In this video, we'll look at how you can use the CHOOSE function for simple lookups. The CHOOSE function doesn't need an external table, and can sometimes replace more complicated formulas based on VLOOKUP, INDEX and MATCH, or nested IFs.
Tip: How to use VLOOKUP to merge tables
How to use VLOOKUP to merge tables
VLOOKUP is a great way to merge data in two tables based on a common ID. This video shows you how in 3 minutes. You can even use this technique to reorder the columns you retrieve.