how to do a drop down menu in excel 2016 youtube

There are a few ways to create a drop-down list on Excel. Create a drop-down list by manually entering data You will now have a drop-down list menu located in the cell you chose from step 3. The Source bar will include the entire cell range that you select in the above steps. Step 7: In the Data validation mini pop-up window, select the Arrow button. From here, simply select the range of cells by dragging the cursor from the first cell down to wherever your last cell is located.

Step 6: You’ll be taken back to your spreadsheet’s main view. An arrow will be displayed on the edge of the Source field. Step 5: Within the Allow menu, select List. Step 4: Go to the Data tab and select the Data validation button or choose Data validation from the drop-down menu. Step 3: Select the cell where you want the drop-down list to appear. Microsoft is slowly lifting Bing Chat’s restrictive turn limits Jasper AI: how to use the ChatGPT alternative nowĬhatGPT: how to use the viral AI chatbot that everyone’s talking about

How to do a drop down menu in excel 2016 youtube