Select a cell or range you want to fill with dropdown menus. Right-click and choose Dropdown from the context menu. You might need to scroll down to see this option near the bottom.

We will also show you how to make a colored and nested drop-down list. If you use Microsoft Excel as your preferred analytic tool, you might already be familiar with the concept called conditional ...