Quick LinksUsing a Column in a Formatted Excel TableUsing a Column in an Unformatted DatasetMicrosoft Excel's Data Validation ...

Microsoft Excel lets you add two types of buttons to a worksheet: option buttons and ... right-click it and select "Format Control" from the drop-down menu to edit its properties.

Doing so will make the drop-down list dynamic. When you update the list at the table (sheet) level, Excel will automatically update the list in the drop-down. Now, let’s add the drop-down list ...