Quickly Create Drop Down List in Excel | Microsoft Excel Tutorial |
HTML-код
- Опубликовано: 15 окт 2024
- Quickly Create Drop-Down List in Excel | Microsoft Excel Tutorial | #shorts
Hello Friends,
In this video, you will learn how to create a drop-down list in Excel. Creating a drop-down list in Microsoft Excel is very and useful. You can create a drop-down list in excel and can do data entry very fast. It's a very time-consuming feature and you must use this in your workbook.
To know how to quickly create a drop-down list in excel, watch the video...
Discussed in this video:
1. How to create a drop-down list in excel.
2. Excel drop-down list
3. Excel data validation tab
4. Drop down list in excel 2016
5. Microsoft Excel Tutorial in Hindi
#officeguruji #dropdownlistinexcel #msexceltutorial #microsoftoffice #microsoftexcel
Excel Beginner to Advanced Course: • Excel Beginner to Adva...
Best Excel Tips and Tricks: • Microsoft Excel Tutorials
Best Word Tips and Tricks: • Microsoft Word Tutorial
.............................................................................
About: "Office Guruji" is one of the best Channel for free Tips and Tricks tutorials about Microsoft Office like MS Word, MS Excel, MS PowerPoint and Windows 10, Windows 11, Internet, Online Earning, and Online Learning which can be very helpful for your daily life.
Like, Share and Comment on My Videos, SUBSCRIBE this channel and stay tuned in this channel for further updates.
Very helpful
Thank you sir 🤗🤗🤗🤗🤗🤗🤗
Most welcome
It’s very helpful thanks
Can you please explain how to enter a drop-down list in a form of excel
Apan ne jitna column number tak select kiya utne tk hi ye validate hoga kya
Thanks very much sir
Sir apne Jo states ke name alag se likhe the toh usse hum all select kerke cell address main state likh ke enter bhi toh ker sakte hai na and then source main direct =state kerenge tab bhi drop down list lagega na
Thank Sir.. It's really useful
Thanks Sir
Welcome 🤗
Thank you
Thank you so much
Or us state ko color se kaise fill kre?
Thanks
Thanks bro
I have seen few of videos but at my case, i am unable to see the data validation option inside the data
Data tab me "text to column" ke paas ek symbol he... usiko click karne par "data validation" option aa raha he bhai
Hello
हेलो सर नमस्कार . मेरा नाम अजय मंडल। एक ऐसा Drop down लिस्ट बनाना चाहते है जो की हम एक वर्क बुक में काम कर रहे हो। और नाम लिस्ट दूसरा वर्क बुक में हो।
Dtnamic list kaise banate hein ??
Data validation that doesn't work for me...
2 nd sheet par click hi nahi hi rahi hai
Works
I am not able to understand the language of this video
Thanks sir
Thanks
Works
Hello
हेलो सर नमस्कार . मेरा नाम अजय मंडल। एक ऐसा Drop down लिस्ट बनाना चाहते है जो की हम एक वर्क बुक में काम कर रहे हो। और नाम लिस्ट दूसरा वर्क बुक में हो।
Jo data aap drop down me dikhana chahte hai use select karke name box me jakar koi name dekar enter kare phir jis sheet me drop down list banana hai vaha drop down list banaye aur input box me =name (jo naam apne range ko diya hai) vah type kar enter key press karen. Dusri sheet ka data is sheet ki drop down me dikhne lagega.
Ye sirf excel ke purane version me hi karna hai. Naye version me aap dusri sheet ke data se bhi drop down list bana sakte hai