how to make | insert |create drop down list from another sheet in excel in hindi- It is quite easy to create a data validation drop down list among worksheets within a workbook. if the list data you need for the data validation locates in another worksheet, what would you do? In this tutorial, you will learn how to create a drop fown list from another worksheet in Excel in details. its easy to make drop down list in excel 2010 2013 and 2016 because Microsoft office 2010 2013 and 2016 has added some new feature to data validation in excel 2010 2013 and 2016 you can easily navigate from sheet to sheet while selecting data range in data validation to create drop down list. but in ms excel 2007 you cant select data range from another worksheet here is the step by step procedure how to use data validation to create a drop down list from different sheet inside the whole workbook. Must watch this video
Excel Formula Tab in Hindi - How To Use Name Manager And Define Name in EXCEL | In Hindi https://youtu.be/FyHyEm40OgM
protect sheet & Lock Cell excel in Hindi 2007 | 2010 | 2016 | 2013 https://youtu.be/AN1JEk8MHZk
____________________________________________
Data Validation Part 1: https://youtu.be/U3XdCUmNaBg
* Data Validation to allow only whole numbers between an upper and lower
limit
* Data Validation to allow only decimal numbers below or equal to an upper
limit
* Create an Input Message for your Data Validation
* Error alert Message with "Stop"
* Error alert Message with "Warning"
* Error alert Message with "Information"
____________________________________________
Data Validation Part 2: https://youtu.be/-IDqfwby5MM
* Data Validation drop down list using a range of cells
* Data Validation drop down list using a Defined Name
* Make data validation list from another worksheet in excel 2007
____________________________________________
Data Validation Part 3: https://youtu.be/VjVpMVO8Jq0
* Data Validation to allow only dates between an upper and lower limit
* Data Validation to allow only times above or equal to a lower limit
* Data Validation to allow a certain text length
____________________________________________
Data Validation Part 4 : https://youtu.be/ZTlymO0uug4
* Allow only numbers in cell & Set limit of digits to accept.
* Allow only text in cell & set character limit to accept.
* Allow only 10 digit mobile number in cell
____________________________________________
Data Validation Part 5 : https://youtu.be/vzeWlggal88
* Prevent Duplicate Entries In Column
* Allow Only Unique Entries - Avoid duplicate entries in excel using
custom data validation.
____________________________________________
Data Validation Part 6: https://youtu.be/EX2ZahZ3pHo
Auto Updating DropDown List In Excel Hindi ||
Dynamic DropDown List
____________________________________________
Data Validation Part 7: https://youtu.be/Ig245IO7lPs
How To Create Data Validation Dependent Drop Down List In Excel || Best
Video || Hindi || HD
____________________________________________
Data Validation Part 8: https://youtu.be/tn4ShvcvBls
EXCEL ये विडियो जरूर देखें - Allow Only Entries Starting With Specific Alphabet / Text
/Number
____________________________________________
Data Validation Part 9:https: https://youtu.be/WULhnIsKguU
Custom Data Validation- To Allow only Uppercase Text Entries In Excel
____________________________________________
Data Validation Part 10:https: https://youtu.be/HwVbH_x6nMk
How To Create Searchable Drop Down List In Excel || Hindi || HD
____________________________________________
Data Validation Part 11:https: https://youtu.be/-IDqfwby5MM
how to create drop down list from another sheet in excel || Hindi | using data validation
____________________________________________
Data Validation Part 13: https://youtu.be/e6R4zZdlxHY
EXCEL में Data Entry करने वाले जरूर देखे 👍 5 Cool Custom Data validation Tips Everyone should know
Hope you will like the video. Thanks for watching.
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
_____________________________________________________________
ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA
ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2
MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA
HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8
COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn
---------------------------------------------------------------------------
Subscribe to my channel: https://www.youtube.com/deepakeduworld
Like my Facebook page: https://www.facebook.com/deepakeduworld
Follow on LinkedIn: https://www.linkedin.com/in/deepakedu...
Facebook Group : https://www.facebook.com/groups/cse92/
***********************************************************
Thanks for Watching
Happy Learning
how to create drop down list from another sheet in excel || Hindi | using data validation list of us presidents | |
| 1,262 Likes | 1,262 Dislikes |
| 80,865 views views | 290K followers |
| Education | Upload TimePublished on 13 Nov 2017 |
Không có nhận xét nào:
Đăng nhận xét