Exceljet

Quick, clean, and to the point

Move one cell down

Windows shortcut 
↓
Mac shortcut 
↓

Moves current selection one cell below the active selection.

222 Excel Shortcuts for Windows and Mac

Related videos

Tip: How to use VLOOKUP with an Excel Table
How to use VLOOKUP with an Excel Table
This video shows how to setup VLOOKUP with a table, and how to use the MATCH function inside VLOOKUP to generate a dynamic column index. This makes it easy to refer to columns by name inside VLOOKUP, instead of hardcoding the column number. As a bonus, you can reorder the columns and the formula will keep working correctly.