Data Validation Drop Down List - How to make drop down list in excel

Data Validation is an important in Microsoft excel.
This video will explain how to create drop down list in few seconds.
This session will cover the following;
Drop Down List in Cell
Data Validation in Excel
Excel Data Validation
How to Create drop down list in Excel
How to create a data validation rule in excel
How to make drop down list in excel
Make sure to SUBSCRIBE to this channel and be a part of our Learning Platform!!
/ microsoftofficelearning
Other Relevant Formulas are as follows;
5 Advance Shortcuts: • Keyboard Shortcuts | E...
Format Painter: • Efficient Use of Forma...
7 Shortcuts: • Excel Basic Shortcut |...
This Channel is the best source for E-Learning when it comes to Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Access and Microsoft Outlook*******
#DataValidation #DropdownList #Excel #Elearning #MicrosoftOfficeLearning #howtocreatedropdownlistinexcel

[@MicrosoftOfficeLearning]

Please watch and share your valuable opinion to improve this Learning Platform. Thanks

[@sayediftekharraheman6324]

Sir amezing information.
Thankyou sir
I have a question.
Sir I'm having 20 rows with data validation drop-down, so I want to copy all the rows ,but paste only which cell having data and black cell will not be pasted.
Only paste cell value not blank cell.
⚠️All rows are having data validation drop-down⚠️
Please sir help me 🙏🙏🙏

[@MicrosoftOfficeLearning]

You can use visible cell only function (Go to special) but need to hide rows for this

[@ianpatrick23]

Thank you so much for explaining data validation in Excel!

[@MicrosoftOfficeLearning]

Most Welcome

[@rheamtc]

How to remove or hide the choices beside the table?

[@rodeomad]

Exactly what I needed

[@MicrosoftOfficeLearning]

Happy to know

[@momoney1327]

You're a lifesaver! I'm subscribing!

[@MicrosoftOfficeLearning]

Please to know 😊

[@pachinko8809]

Question. Can I add a value to another column alongside this list with a set value? That value is based off of the item chosen in list ?

[@alpanarawat83]

It was helpful for me. Thank you 🙏❤

[@MicrosoftOfficeLearning]

My pleasure

[@kidii44]

Thank you that was very helpful

[@MicrosoftOfficeLearning]

My pleasure

[@Bumba_Lama]

Great Subscribed 👍

[@salikghafoor4577]

Its really good to share knowledge to help others

[@MicrosoftOfficeLearning]

Thanks a lot

[@SaifAli-ip3fq]

​@@MicrosoftOfficeLearningthen how to remove data validation drop down 🤔

[@MicrosoftOfficeLearning]

@@SaifAli-ip3fq Select the column then go to data validation option and select clear all

[@pradeepkumarkanhar3128]

Thanking you sir

[@MicrosoftOfficeLearning]

My pleasure

[@bijaytanty8434]

Thanks

[@Arvindrai116]

Thanks

[@MicrosoftOfficeLearning]

my pleasure

[@ashfaqsheikh6611]

Same ye hi formula mobile version me ho skta hai, please video upload kreen

[@reichenbach3200]

Nice video sir. I have a question, can we make the list without making it in the other cells?

[@reichenbach3200]

nvm, i found the way. Just separate the options in "source" with the " ; " symbol

[@MicrosoftOfficeLearning]

@@reichenbach3200 If you want to apply same list on other columns or cells then just Ctrl+C and Ctrl+V.

[@sayediftekharraheman6324]

Sir amezing information.
Thankyou sir
I have a question.
Sir I'm having 20 rows with data validation drop-down, so I want to copy all the rows ,but paste only which cell having data and black cell will not be pasted.
Only paste cell value not blank cell.
⚠️All rows are having data validation drop-down⚠️
Please sir help me 🙏🙏🙏

[@ericamaecabrera9144]

I have Amount below that have in and out, then i have bank with dropdown list ( Gcash and Gotyme have also in and out) in which bank i want to go the amount. How can i move that amount based on the drop down list. Thank you

[@MicrosoftOfficeLearning]

It might worth using vlookup on bank name to show value in front. Thanks

[@fatimibrahimova1548]

Salam öncədən təşəkkürlər 🌸 nəyi yanlış etdim anlamiram mende information verir ki The date you entered for the Start date is invalid.

[@unlimitedGK-om8bs]

🙏🙏🙏 spectacular

[@rahuldagade561]

How to insert colour in drop down list

[@MicrosoftOfficeLearning]

Data validation with Conditional Formatting

[@kingkonglee2103]

SAVE ME 30 MINUTES OF SEARCH TIME THANK YOU

[@MicrosoftOfficeLearning]

Happy to know

[@moodyodiaslowedxreverb]

After adding in drop down the product name dlt why

[@MicrosoftOfficeLearning]

It shouldn't be deleted. Is there any hidden cell or row in your data? It can have impact as well.

[@simsonfrancis]

when typing letter not display this list?

[@MicrosoftOfficeLearning]

Can you please elaborate a bit more please?

[@hiideashi925]

Gud job

[@MicrosoftOfficeLearning]

Thanks

[@nextlevelrock5611]

👍

[@sharran9]

How to do the same thing with adding different colors in Excel

[@Office-Monk]

You can do conditional formatting once you are done with data validation. Even conditional formatting can be done before data validation

[@MicrosoftOfficeLearning]

Please use conditional formatting for this purpose

[@himanshuvijay9787]

How to Remove it

[@MicrosoftOfficeLearning]

Select the selected cell and go to data validation option and press clear all

[@helloworld2041]

How to remove thus

[@Office-Monk]

Select the cells or the whole column where data validation is applied. Go to data validation. Once the window pops up, click on clear all on left bottom and Boom, all the validation rules will get cleared