Microsoft groups objects such as drop-down lists in a category called data validation. These objects help spreadsheet creators control the type of data and values that other users input into cells.

How to Insert the Same Drop-Down List Into Multiple Cells of an Excel Spreadsheet. If you use simple copy and paste methods to duplicate an Excel drop-down list, you may discover a problem; when ...

I often want to select more than one option in a drop-down list. For example, when there’s a collection of colors to choose from, I might like more than one color. Or, in a document where we ...

In the Android Google Sheets app, tap the three-vertical dots menu (upper right), then Data Validation. Next to Criteria, select any option other than List From Range or List Of Items.

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.