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.
Download 200+ Excel Shortcuts
Awesome! Thanks so much. Your website has been a HUGE help! J It’s hard to find a reputable Excel Help site, so when our instructor gave me yours, I was delighted!
