How to easily add drop-down lists in Excel What you'll need ... A drop-down list lets users select an item to fill the cell ...

Step 1: Create a Drop-down List The first step is to create ... Press F4 to make this an absolute reference, and add a comma.