In this post, we will show how to create a dropdown list in Microsoft Excel ... Go to Data > Data Validation. Select the List from the Allow menu. Write down your options in the Source box.

you need to install the Live Data Connector on your PC to work with Microsoft Excel and create a data source for it. Here's how: You've now set up a data source that can be used to bring your ...

All you need to do is follow these steps: Also: How to add a drop down list in Google Sheets No formula is needed to create ...