When you release the cursor at the end of the cells you’re selecting, the window will maximize again. Note that the pop-up window will minimize as you perform this action. (You can also type in the cell range yourself if you’re comfortable with the format.) You can use a new sheet in your workbook or existing cells where you have the items entered.Ģ) Click the cell where you want to insert the drop-down list.ģ) Open the Data tab and click Data Validation from your ribbon.Ĥ) In the pop-up window, click the Settings button.ĥ) Under Validation criteria > Allow, select List.Ħ) Click inside the Source box and then drag through the cells that should appear in the drop-down list. Then, follow these steps.ġ) Enter your list items onto a spreadsheet. Open Microsoft Excel and the document where you want to add the drop-down list. Here’s how to quickly create a drop-down list in Excel on Mac. They come in handy for selecting items like colors, sizes, products, people, days, and so much more. Drop-down lists are no different you can create one in just a few clicks.ĭrop-down lists in Excel are ideal for limiting the options for cell entries. Using custom lists in Microsoft Excel on your Mac makes tedious data entry relatively quick and easy.
0 Comments
Leave a Reply. |