How To Create A Drop Down List In Excel

If you are looking to get more advanced in Microsoft office, one of the useful things to learn is how to create a drop down list in Excel. Data entry is faster and more accurate when you use a drop down list that limits the entries people can make in a specific cell.

Find more Excel guides here

This allows a person to select a sell, then the drop down list will appear and they can make a selection. All you need to know is how to create a drop down list in Excel.

ADVERT

How To Create A Drop Down List In Excel

How To Create A Drop Down List In Excel
Credit: Microsoft
  • Step 1: Pick and then select the cell or cells that you want to put the drop down lists in.
  • Step 2: On the toolbar, select DATA then Data Validation.
  • Step 3: In the dialogue, change Allow to List
  • Step 4: Select Source, then type the text or numbers (which should be separated by commas) that you want in your list, then click OK.

That’s it, you should have a fully functioning drop down list that will help keep your data-limited and organized. It is such a simple process, and you can set multiple cells at once if you want the same list in them, which is really helpful too.

The fighting in Ukraine is causing families to flee their homes. Please give now to save lives and protect people in need. Donate today!

Keep the conversation going by heading over to our Facebook and Twitter pages. You can also find us on Instagram, TikTok, and YouTube. Be sure to also check out our friends over on GameByte and Sporf.

ADVERT

Along with the latest games, merch, and accessories, the GameByte Shop has an epic Loyalty Points Scheme – earning you points for every £1 you spend. Sign up to hear about exclusive deals, PS5 console drops, and more!

<div class=”klaviyo-form-VAkrCV”></div>

Featured Image Credit: Microsoft

ADVERT