Exceljet

Quick, clean, and to the point

Show the active cell on worksheet

Windows shortcut 
CtrlBackspace
Mac shortcut 
⌘Delete

This shortcut will scroll the screen to show the active cell on the worksheet. It works when there is only one cell selected or when there are multiple cells selected.

222 Excel Shortcuts for Windows and Mac

Related videos

Tip: How to find missing values with COUNTIF
How to find missing values with COUNTIF
In this video, we use COUNTIF to compare lists and count values that belong to both lists. We also "flip" the formula to count values in one list that are missing on the other.