A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.