Select active cell only
Windows shortcut
ShiftBackspace
Mac shortcut
⇧Delete
When multiple cells are selected, this shortcut will leave only the active cell selected.
Related videos
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.
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.
