Skip to content

5000+ Great Articles

Best Articles & Essays: Interesting Articles to Read Online

  • Best kitchen calculator 2020

    Best kitchen calculator 2020. 1 - Calculated Industries 8300 KitchenCalc Recipe Conversion and Culinary Math Calculator with Digital Timer for Chefs

  • Compress Videos for YouTube Without Losing Quality How-To
  • Yarışda kim qalacaq: Avropa Liqasının pley-off oyunları Dasinmaz emlak elanlari, ev elanlari, ev alqi satqisi, kiraye evler, torpaq, obyekt, bina, bina ev, mənzil, villa, kreditle satilan evler - 814
  • How to fix if Wendy’s app not working? Smartphones
  • Boot Windows 8/10 into Safe Mode Windows 10
  • 13 Typing Games for Kids to Learn How To Type Faster

    In today's digital world, it is very important for children to be able to type. Even in elementary school, technology is the norm, and most kids hav

  • How To Play MKV Files On Windows Media Player Software Reviews
  • Make Multi-Page PDF Files in Mac OS X Tutorials

How to Create Multiple Linked Dropdown Lists in Excel

Posted on October 9, 2020 By bilal 1983 No Comments on How to Create Multiple Linked Dropdown Lists in Excel

Therefore, I wrote earlier about how you can create a simple drop-down list in Excel, which is ideal for validating any data. If you have a range of values ??that people need to re-enter, it is best to create a drop-down list so that you cannot enter invalid data.

Let’s start with an example to better understand how we can use linked lists in Excel. Let’s say I have a table with three columns that represent the brands of a car: Toyota, Honda, and Nissan. The strings represent the models:

How to Create Multiple Linked Dropdown Lists in Excel

So what we could do is create one dropdown menu containing brands like Toyota, Honda and Nissan, and the second dropdown contains models. If we had chosen Toyota, the second dropdown would show the Prius, Camry and Solara.

To do this, set up the data in the table as shown above. Now select the categories (row 1) and give the range a name in the upper left text box above column A.

– /

How to Create Multiple Linked Dropdown Lists in Excel

Now that you have named the range for the categories, you need to name the range for each of the options as shown below:

How to Create Multiple Linked Dropdown Lists in Excel

How to Create Multiple Linked Dropdown Lists in Excel

How to Create Multiple Linked Dropdown Lists in Excel

To create the first dropdown list, you need to click on any blank cell and then click on the data ribbon and click on Data Validation.

How to Create Multiple Linked Dropdown Lists in Excel

Now select “List” in the “Allow” field and enter “= carbrands” in the “Source” field. Please note that you must enter whatever you have named for your categories, not necessarily “car brands.”

How to Create Multiple Linked Dropdown Lists in Excel

Click OK and your first dropdown will appear. Now, be sure to write down which cell you put the first dropdown in, because you will need it later, like E2, etc.

Now click another blank cell and go to data validation again. Select List again, but this time enter “= Indirect (E2)” in the source. Instead of E2, you will place a cell for the first dropdown you created.

How to Create Multiple Linked Dropdown Lists in Excel

The indirect function will basically take the selection you made in the first dropdown and use it for the second. Please note that if you receive a message like “The source currently has an error, you want to continue”, this means that you have not yet selected a value for the first drop-down list (you cannot select NULL).

How to Create Multiple Linked Dropdown Lists in Excel

This is it! Pretty cool, right? You can go deeper if you like, just use the second dropdown menu as a source for the third dropdown and so on. Enjoy!

–

Share this:

  • Facebook
  • X
Office Tips

Post navigation

Previous Post: How to Change the Limit Reservable Bandwidth in Windows
Next Post: How to Force Group Policy Update in Windows 2000, XP, Vista, 8 and 10

Related Posts

  • How to Convert a Word Document to PDF Office Tips
  • How to Repair Any Version of Microsoft Office Office Tips
  • How To Use Flash Fill In Excel Office Tips
  • How To Recall An Email In Outlook Office Tips
  • Fix End Tag Start Tag Mismatch Error When Opening DOCX Files Office Tips
  • How to Securely Password Protect an Excel File Office Tips

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Archives

  • December 2023
  • November 2023
  • October 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • March 2021
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018

Categories

  • – 436
  • – 939
  • 1xBet giriş, güzgü 1 xBet Azərbaycanda rəsmi sayt – 413
  • AI Tools & Guides
  • Amazon Web Services
  • Apple Watch
  • blog
  • Calculator
  • Computer Tips
  • Cool Websites
  • Dasinmaz emlak elanlari, ev elanlari, ev alqi satqisi, kiraye evler, torpaq, obyekt, bina, bina ev, mənzil, villa, kreditle satilan evler – 814
  • Featured Posts
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • islamic Books
  • Linux
  • Linux Tips
  • Mac OS X
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • OS X
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tools Review
  • Troubleshooting
  • Tutorial
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Windows XP Tips
  • Wordpress
  • бонусы до 250%, официальный сайт в Узбекистане – 69
  • Мостбет Уз Ставки на спорт и казино в букмекерской конторе Mostbet Uz – 527
  • ベラジョンカジノの出金方法一覧【2023年 最新】出金限度額・出金の流れ・出金手数料・出金条件 – 466
  • Mirror Your Android Screen to Any Computer With TeamViewer
  • Fixed macOS Error – You can’t open the application because it may be damaged or incomplete
  • Create a WiFi hotspot from Android which is already connected to WiFi
  • 11 LGBTQ+ flicks that premiered in 2020 > Taimi
  • 5 Effective ways to stay Anonymous on Android
DMCA.com Protection Status

Recent Posts

  • How to Download Torrents on Android
  • Mirror Your Android Screen to Any Computer With TeamViewer
  • Fixed macOS Error You can’t open the application
  • Create a WiFi hotspot from Android which is already connected to WiFi
  • Newyes A4 Portable Wireless Thermal Printer Review

Recent Comments

  1. Instagram stories not working/loading? Try These 9 Fixes on Can’t update PS5 system software? Try These 10 Fixes
  2. How to Link to a Specific Part Of A Webpage & Share it on Best PDF to Word Converter Online (Free Without Email)
  3. See What’s Taking up Space on Your Hard Drive on 7 best 3D scanning apps for Android and iOS
  4. Make your Devices Read Out Text, With Text to Speech on 9 Best 10K Running Apps for 2023
  5. How to Find your Router’s IP Address on How to Fix Apple CarPlay Not Working? 7 Possible ways
  • How to Fix “Your PC Ran Into a Problem And It Needs to Restart” Error Help Desk
  • Everything You Need To Know About 360-Degree Video Computer Tips
  • How To Stop iTunes From Automatically Opening When You Click On An iOS Link Computer Tips
  • Find Out If The Email You Sent Was Opened Or Not How-To
  • How to watch Tour de France 2023 online without cable Cool Websites
  • How To Download Maps on Google Maps for Offline Viewing Google Software/Tips
  • How to Fix If iPhone Disconnecting From Wi-Fi? iPhone
  • Best calculator watches for men 2020 black

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version