Learn more about Teams. Asked 4 years, 7 months ago. Active 4 years, 7 months ago.
Viewed times. What is the cause of this and can it be fixed?
It's because. If you encountered a bug or want to suggest a feature in Microsoft Office, we recommend you contact Microsoft Support.
We are not a division, a subsidiary, or a contractor of Microsoft Corporation, and we are not responsible for their decisions. Also, we are not responsible for access configuration or software updates in your company. Contact your company support team and install latest updates before asking questions.
Creating a Drop-Down List in a Cell. Excel Drop-down lists make it easier and more efficient to enter data into your spreadsheets. Simply click the arrow and select an option.
You can add drop-down lists to cells in Excel containing options such as Yes and No, Male and Female, or any other custom list of options. Drop-down lists are created using the Data Validation feature.
To begin, enter the list of age ranges into sequential cells down a column or across a row. We entered our age ranges into cells A9 through A13 on the same worksheet, as shown below. You can also add your list of options to a different worksheet in the same workbook.
To do this, select all the cells containing the drop-down list items and then enter a name for the cell range into the Name box above the grid.
Using custom lists in Microsoft Excel on your Mac makes tedious data entry quick and easy. And, drop-down lists are no different. You can. Create a drop-down list in Excel. Excel Select the cells where you Learn more about creating drop-down lists in Excel for Mac
We named our cell range Age. The Data Validation dialog box displays.