How to Create a Drop Down List in Excel

Channel:
United States Gauging Gadgets
Subscribers:
509,000
Published on ● Video Link: https://www.youtube.com/watch?v=M_ngjCED5_c


Category:
Tutorial
Duration: 2:58
2,416 views
29

How to create a drop-down list in Excel? In this tutorial, I show you how to easily create a drop down list in Microsoft Excel. This means you can add a drop down list to your spreadsheet with any options you want. Drop-down list are perfect for pre-defined answers that makes it easy to quickly select an option. Let me know in the comments if you have any questions while you create a drop down list in Excel

More Excel Tips & Tutorials: https://www.youtube.com/playlist?list=PL8griS8Ww-KlEuiwCQdUMvajiMc2s29vQ

Follow the steps below to create a drop down list in Excel:
1. Open Excel on your Windows 10 computer or Mac.
2. Create a table containing the answers you want to include in your drop down list.
3. In the top menu of Excel make sure you are on the Data ribbon.
4. In the Data ribbon, select Data Validation.
5. In the Data Validation window under the Settings tab find the Allow drop-down menu and select List.
6. Then click the empty text box and highlight the table containing the items you want in your drop down list.
7. Select OK.

#Excel #Spreadsheet #MicrosoftExcel

Create a Drop Down List in Excel Chapters:
Intro - 00:00
Create Table of Drop Down Options - 00:25
Create Drop-Down list in Excel - 01:07
Outro - Please Subscribe - 02:39

Disclaimer: Some of the links in this description are affiliate links. This mean Gauging Gadgets earns a small commission from qualifying purchases through these links. This helps support the channel and allows us to continue to make videos like this. Thank you for the support!

😀 SUPPORT THE CHANNEL 😀
TubeBuddy YouTube Toolkit: https://www.tubebuddy.com/gauginggadgets/yt
All Thumbnails Made with Canva: https://partner.canva.com/gg
StreamYard Livestreaming Tool: https://geni.us/streamyardyt
Nord VPN: https://go.nordvpn.net/SH47u
Install Google Play Store on PC: https://bstk.me/onaTbrrUc
SUBSCRIBE NOW!: https://youtube.com/c/gauginggadgets?sub_confirmation=1
SEND ME A TIP!: https://www.paypal.me/GaugingGadgets

FOLLOW ME!
BLOG: https://GaugingGadgets.com
FACEBOOK - http://fb.me/GaugingGadgets
TWITTER - http://twitter.com/GaugingGadgets
REDDIT - https://www.reddit.com/r/GaugingGadgets/
INSTAGRAM - https://instagram.com/GaugingGadgets/
TWITCH - https://www.twitch.tv/GaugingGadgets
Learn How To Crochet: https://www.youtube.com/c/CrochetWithJulie

HOW DO I DO IT? (Paid Links)
My YouTube Setup: https://gauginggadgets.com/youtube-setup/
Lenovo Legion 5-15IMH05H: https://geni.us/Legion5
Turtle Beach Elite Pro 2 + SuperAmp Pro: https://geni.us/TurtleBeachEP2
700W Lighting Kit - https://geni.us/LightingKit
Blue Yeti USB Microphone - https://geni.us/USBMic
Logitech C920 Webcam - https://geni.us/HDWebCam
Cell Phone - Pixel 2 XL - https://geni.us/FilmingPhone
Vanguard VS-82 Table Tripod - https://geni.us/VS-82



Other Videos By Gauging Gadgets


2022-04-08How to Enable Auto Clicker on a Chromebook
2022-04-07How to Change Language on Amazon App - 2022
2022-04-06How to Check if Google Account has been Hacked - 2022
2022-04-04How to Disable or Enable Touch Screen on Chromebook
2022-04-03How to Install Steam on Chromebook - 2022
2022-04-02How to Change Google Language Settings to English - 2022
2022-04-01How to Link PayPal to Bank Account - iOS & Android in PayPal App
2022-03-31How to Turn Off Twitter Sensitive Content Setting - 2022
2022-03-30How to Remove Duplicate Rows in Excel
2022-03-29How to Delete PayPal Account - PC & Mobile
2022-03-28How to Create a Drop Down List in Excel
2022-03-27How to Link PayPal to Bank Account
2022-03-26How to Fix Epic Games Launcher Won't Open or Not Opening
2022-03-25How to Delete Search History on Google Maps - WORKING 2022
2022-03-24How to Receive Money on PayPal
2022-03-23How to Fix Epic Games Launcher is Currently Running Uninstall Error
2022-03-22How to Drop a Pin on Google Maps
2022-03-21How to Convert PDF to Excel - EASY
2022-03-19How to Delete Google Play Store Search History - 2022
2022-03-17How to Turn On or Off iMessage on iPhone - 2022
2022-03-16How to Copy Facebook Page Link - 2022


Tags:
How to Create a Drop Down List in Excel 2022
How to Create a Drop Down List in Excel
Create a Drop Down List in Excel
excel drop down list
drop down list in excel
how to create a drop-down list in excel
how to create a drop down list in excel
make dropdown list in excel
drop-down list to an excel cell
dropdown in excel
dropdown list excel
how to create drop down list in excel
drop down list
microsoft excel
excel tutorial
excel drop down list tutorial
drop down