How To Create a Drop Down List in Excel | Quickly and Easily
Creating a drop-down list in Excel is like giving someone a menu instead of asking them what they want to eat without any options. It makes entering data faster and easier because you can just pick from a list of choices you've already set up. This is super helpful because it:
📣 Below you will find a step by step guide to How to create a drop-down list in Excel.
First of all select the cell where you want to set the drop down list , under the data , you will find Data Validation .
click data validation . Once click data validation , You will see a popup window .
from allow section select List
click source field and type there your text and separate them by coma.
For a long list you can use a different sheet . where you will write the list items. Select all the cells and click ok.
so it was super easy to add a drop down list in excel .
#Excel #microsoft #tutorial
❤️
--------------------------------------
✅ Watched the video!
🔲 Liked & Shared ?
🔲 Subscribed?
--------------------------------------
❤️ Follow Us
↗️ Facebook - / brimitech