Microsoft Excel for PC Logo
Lebogang Posted on Sep 25, 2013

I want to make only specific options available on a drop down menu based on what was selected on the first drop down menu. So you'll select an option from menu1. Then only options based on what was selected in menu 1 will be available in menu 2. How do I do that in Excel?

1 Answer

Zenka Sabala

Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

New Friend:

An expert that has 1 follower.

Greenhorn:

A rookie expert who has answered 20 questions on their first day.

  • Contributor 22 Answers
  • Posted on Oct 23, 2013
Zenka Sabala
Contributor
Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

New Friend:

An expert that has 1 follower.

Greenhorn:

A rookie expert who has answered 20 questions on their first day.

Joined: Oct 23, 2013
Answers
22
Questions
0
Helped
2803
Points
23

You will need to use named ranges and the INDIRECT function to do the dependent validation list.
You will find a more detailed instruction in this page:
http://www.contextures.com/xlDataVal02.html

3 Related Answers

Anonymous

  • 108 Answers
  • Posted on Feb 05, 2008

SOURCE: Asking Excel to insert a drop down list based on previously entered text

Yes...no....yes....and yes. And if that sounds like a funny response let me explain. First of all you can write a formula for a specific cell (or cells or interrelated cells where you menus would display). It takes a while and if you are new to the syntax it could take a couple hours even (let's assume you are not a math major). Using Access, for something this apparently simple, I would not suggest (another learning curve but admittedly a reasonably easy one). But, this is the second yes, the easiest way to do this would be to simply insert a "comment". When you hold the cursor over the cell...your data...i.e. menu...will pop up. And yes...(last yes) you could have Sunday thru Monday across the top and Breakfast, lunch and dinner in the right hand column. Now this assumes what you have said is what your are trying to do...effectively meal planning...and you are not trying to plug in the inventory in the fridge to develop a shopping list.

Lastly...yes I could write the formula....but not knowing what you do (and figuring if you are going to use Excel at all you really do need to learn how to do it) I would be wasting a bit of time. Hope this helps...Tango.

Ad

Anonymous

  • 101 Answers
  • Posted on Apr 07, 2008

SOURCE: DropDown menus in Excel

The quickest and easiest way is to go to the data menu and choose filter and then autofilter. This will allow drop downs on all columns which can be picked to filter one or more columns. Custom in the drop down list will give you further options.

Anonymous

  • 132 Answers
  • Posted on Aug 17, 2008

SOURCE: Excel

Would you not be better off with a pivot table ?

To use multiple drop downs - each listing would need to be associated, or have a column that causes a relationship.
When selection 1 is made - a formula will dictate what fields to make visible (available) in the next menu..
you could build a macro in that will 'lift' the formulised data, and 'paste as values' it into a control area that will then give you a definitve second list based purely on the initial drop down.

Hope this makes sense

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
2answers

How can I change language back to English on a Dora flip phone

Hi Mate,

The default language is determined by the SIM card. But if you need to change it, here's how.
1. Press Menu, scroll to Settings (wrench icon) and press OK.
2. Select General and press OK.
3. Select Language and press OK.
4. Scroll up / down to select a language, then press OK.

Cheers!!
Sep 29, 2018 • Cell Phones
0helpful
1answer

Boot menu

Your computer's BIOS, or basic input/output system, regulates several important system functions before your operating system loads.
The BIOS can even tell your operating system which device it should load from, whether the computer's hard drive or a USB stick.
You can control this and other options from the BIOS boot menu.
If you own an Acer Aspire One netbook and want to access the boot menu, you can do so by entering the computer's BIOS.

Turn off your Acer Aspire One netbook.
Turn it back on.

Press "F2" when you see the Acer logo appear as the computer boots up.
This will open the computer's BIOS menu.

Press the arrow keys to highlight the Boot option.
Press the down arrow key to highlight specific boot settings to change.


also
Windows operating systems support a variety of boot options on the Windows Advanced Options Menu that allow you boot your computer based on your need.

They support boot options such as Safe Mode, which is generally best for troubleshooting and virus removals; or the Safe Mode with Networking, which allows to use an Internet connection while troubleshooting system problems.
Within seconds, you can access the boot menu and select the option that works well for the task you want to accomplish.

Shut down all currently running programs and restart your computer.
Press "F8" repeatedly before the Windows icon shows up on your screen.
This will bring you to the "Windows Advance Options Menu."

Scroll down and select the boot option you want.
Press "Enter."You can select from "Safe Mode" "Safe Mode with Networking" or your regular booting option.
Choose the boot option based on your need.
For troubleshooting, it is advisable to select "Safe Mode" because only a certain amount of drivers and resources run allowing you to resolve issues.
0helpful
1answer

D865gbf- sound driver

Go to the following link : Download Drivers of Intel D865GBF and select an Operating System under the Select an Operating System Drop-down menu (say, Windows XP Professional).

Now under Select a Download Type drop-down menu select Drivers, which will give you drivers for your motherboard model. Amongst them, find the AUDIO driver and click over it to open a new page where the Download option will be available.

Hope this helps, Mrityunjay.

NOTE: If anything goes wrong, please let us know by commenting over this reply.
1helpful
1answer

My voice call and video not working

First update your yahoo messenger, then you need to setup voice call and video settings.
To get started, click on the Messenger menu and select"Preferences". When the Preferences window opens, click "Video & Voice" onthe left hand menu. This will bring up your options on the right hand side: If you know immediately which devices you want Yahoo! Messenger to use foryour camera, microphone etc., just select them in the drop down menu. Dependingon your type of computer and other software or hardware you have installed, youmay only have one or many options available. For a guided setup, click the "Open Voice and Video Setup" link in thePreferences window. This will take you through three setup steps where you canselect the devices you want to use for your microphone, speakers/headset and web cam. After selecting each one in the setup, you'll be able to test andconfirm they are working. Once you've successfully completed the Voice and Video Setupsteps, you'll be ready to start making free PC-to-PC calls.
0helpful
1answer

I NEED TO PRINT DOUBLE-SIDED ON AN hp3150 LASERJET. hOW DO i DO THAT?

Follow these steps to change print settings, and then print in Mac OS X 10.6. Step one: Select your product
  1. In the program from which you want to print, click File , and then click Print . Figure 11: Click File, and then click Printc02458420.jpg
  2. Select your product from the Printer: drop-down list.
Step two: Change print settings
  1. Type the number of copies to print in the Copies text box.
  2. If you want to print multiple copies, select the Collated check box to print the pages of each copy in order.
  3. Select the pages of the print job that you want to print. To print all pages, select All. To print a specific range of pages only, type the page number that begins the page range in the From text box. Then, type the page number that ends the page range in the To text box.
  4. Select the size and type of paper loaded in the product from the Paper Size drop-down list.
  5. Select the orientation for your print job. To print in portrait orientation, click the icon on the left. To print in landscape orientation, click the icon on the right.
Step three: Change the paper type and quality settings
  1. After the Orientation section, click the drop-down, and then select Paper Type/Quality . NOTE: This drop-down usually defaults to the program specific drop-down. In this example, the drop-down is the TextEdit drop-down. Figure 12: Select Paper Type/Qualityc02458421.jpg
  2. Adjust the Paper Type setting to match the paper loaded in the product.
  3. Adjust the Quality setting to change the print quality of the printed page.
  4. Select Print Borderless to print photos without a white border.
  5. To change the color profile or to turn on Photo Fix, click the arrow next to Color Options to display the Color Options menu. Figure 13: Color Options menuc02458422.jpg 1 - Paper Type/Quality menu options 2 - Color Options menu (only available if you click Color Options)
Step five: Print the print job After all the settings match the needs of the print job, click Print on the Print window to print the document or print job.
1helpful
1answer

I lost my web cam driver, i want to reinstall it again but the problem is i dont have the driver at all

Try the following:

1. Navigate to : http://www.logictech.com
2. Select Product Support, from the Support drop down menu.
3. Select either Option 1, 2,3 or 4. If Option 2 or 3 then :

  • Option 2 = Type in Model No. of the product.
  • Option 3 = Select Product Type and Product Name.
Once you have located the Product then do the following :

1. Select Download installation software, drivers and more... from under the Software Downloads heading.
2. Select the OS (Operating System) you are using, xp, vista, windows7 from the Choose OS drop down menu.
3. Select the File type (either 32 bit or 64 bit) from the Select File drop down box.
4. Review the information. Read the Download Instructions section.
5. Click the Download Software button.

Follow any other prompts or questions that are required.

I hope this helps. Regards,
0helpful
2answers

PCV-RX580

ok, you press F2 or F3 to enter into the bios setup.

Thanks
0helpful
2answers

Software problem

Does this happen every time you download something from the internet?

Has the computer turned itself off while doing anything else?

How to Stop Laptop/Notebook Goes To Sleep or Hibernation when Closing Lid in Windows Vista
  1. Log on to your computer as an administrator. Click on Start, go to Control Panel -> System and Maintenance -> Power Options.
  2. Click on Change plan settings for the currently active plan.
  3. Click on Change advanced power settings link.
  4. In the “Power Options” dialog box’s “Advanced Settings” tab for the active power plan, expand Power buttons and lid.
  5. Expand Lid close action.
  6. Change the value to Do nothing for “Lid close action” by selecting a new option from drop down menu for both On battery and Plugged in.

740549c.jpgBased on own preference, it’s possible to set other action from the menu too. Available for selection is Do nothing, Sleep, Hibernate and Shutdown.
  1. Click OK button.
How to Disable Notebook Computer to Stand By or Hibernate on Closing Lid in Windows XP
  1. Log on to your computer as an administrator. Click Start, and then click Control Panel.
  2. Click Performance and Maintenance.
  3. Click Power Options.
  4. Click Advanced tab.
  5. Under “Power buttons” section, select Do nothing from drop down menu for When I close the lid on my portable computer option.

e461aeb.gifAgain, any other settings such as Stand by and Hibernate can be set based on own preference.
  1. Click OK button.
Let me know if this helps - if not - PLEASE, further clairify so we can continue to find a fix for your problem....
1helpful
1answer

Mic

First, be sure to have the latest software from logitech's website, and the latest MSN.

Then perform the following:

Execute the audio and video setup procedure within MSN Messenger 7.5. This procedure will allow you to assign an audio input and audio output device, as well as assign the video device of your choice to work with MSN Messenger.
1. Launch MSN Messenger and select the “Audio and Vide Setup” option from the “Tools” menu.
3172_msnad01.jpg
Figure 1

2. Click “Next to begin the setup process
3172_msnad02.jpg
Figure 2


3. In the “Speaker Setup” window, select the output device you would like to use with MSN Messenger. This step is specific to speakers or headphones. If your speakers or headphone device is connected to your computer, select the device by using the drop down menu provided. You can also set the desired volume level and click “Play Sound” for an audio sample. Once you are comfortable with the your selected options, Click “Next”
3172_msnad03.jpg
Figure 3

4. In the “Microphone Setup” window, select your desired input device from the drop down menu provided. This selection will be specific to a microphone connected to your computer. If your Logitech video camera has a built-in microphone, this option will be presented as “Logitech Mic” with your camera model name in parentheses as shown below. If you have an external headset device connected to your computer which hosts a microphone, select the devices name or model number in the drop down menu. Once your device is selected, adjust the microphone volume level to your preference and click next.
Note: the microphone volume level may need to be tested in order to find a comfortable listening level for you contacts. As a starting point, try setting the level midway and adjust when necessary by re-executing this procedure.
3172_msnad04.jpg
Figure 4

5. In the “Webcam Setup” window, select the video device you would like to use with MSN Messenger. Once selected you should see a display sample in the window provided. You can also click the “Options” button to make camera specific adjustments. Once completed, click the “Finish” button to apply your changes.
3172_msnad05.jpg
Figure 5
6. Once you have completed this process, MSN Messenger should now know the audio input (microphone) audio output (speakers or headphones) and video device (webcam) to use when engaging in an audio and or video conversation.
Not finding what you are looking for?

60 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...