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

I want to create a drop down that will only reflect another drop down menu that has information that's only relevant to the drop down option selected in the first drop down e.g drop down A has options 1,2 and 3. Drop down B has options 1.1,1.2,1.3,2.1,2.2,2.3,etc. If a user selects option 1 in drop down A then only options 1.1,1.2 and 1.3.

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
2808
Points
23

You will need to use named ranges and the INDIRECT function to do the dependent validation list.
Here's a detailed guide on how to do it:
http://www.contextures.com/xlDataVal02.html

5 Related Answers

Biju Panjikaran

  • 48 Answers
  • Posted on Apr 01, 2008

SOURCE: Drop Down Menus

Click on Data (Top menu), Choose Filter from the drop down list, Choose Auto filter from the shown list. Now you get filter list on each column. Choose the filter condition on the column(s) you want and the data get filtered based on the condition you have given.


Fixya?

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

Anonymous

  • 1 Answer
  • Posted on Aug 25, 2008

SOURCE: Excel-formula

how to protect some cells on excel sheet
Dipak

Anonymous

  • 1 Answer
  • Posted on Sep 29, 2008

SOURCE: using drop-down form field in a word 2007 template

You need to protect the form (Protect Document, Editing Restrictions (Filling in Forms) then Start Enforcing Protection, the drop down menu will then work.

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
2answers

Quickbooks is unable to create the data to email an invoice

if not able to email from your QuickBooks then follow tutorial ( if you have some technical knowledge) for solution http://support.quickbooks.intuit.com/support/articles/SLN40921 and need any guidance through technical detail follow http://www.techsupportquickbooks.com/intuit/intuit-help.html .
tip

Excel - Drop Down List Ever wish that you didn't have to type...




Excel - Drop Down List

Ever wish that you didn't have to type out the same thing over and over again? Well you can save time by using Excel's drop down list!


Drop Down Preparation

Imagine that we are creating an Excel spreadsheet to document our purchases from the grocery store. For each purchase we want to mark down the name of the food and the type of the food.
The way a drop down list works in Excel is that it takes values from some place on your spreadsheet and uses them to populate the options in the list. Lucky for us, the type of food is a perfect opportunity to use a drop down list!
In cells A1 through A7 enter the type of food that will be used for the drop down list.


Creating a Drop Down List

Now that we have a source for our drop down list, we can create a begin to create our drop down.
1. Select cells D2 though D20 (We will be creating a drown down list for each cell in this range)

2. Click the Data menu and select Validation
3. Choose List from the Allow drop down menu

4. Click the Source button that appears to the right of the textfield

5. Select our source cells A1 though A7

6. Press Enter and Click OK

Testing Your Drop Down

All of your cells in the Type column should now have a drop down list. To test to see if your drop down works, click on cell D2 and then click on the downward facing arrow and see if all the types of food are available.

0helpful
1answer

I cand remove wrong password on my Email page

Create Menu tab right click in the top of screen (toolbar) you will see a number of toolbar options select the menu bar.

This will add to your screen toolbar File Edit View Favorites Tools and Help
Click tools internet options from the drop down list tick the box and locate the section titled "Browsing History."
Read the description under browsing history to be sure it includes the option to delete temporary files, browsing history, cookies, saved passwords and web form information.
Delete browsing history on exit.
0helpful
1answer

Internet explorer icon is gone and get telus home page back

Create the menu tab on your homepage right click in the top toolbar you should see a number of toolbar options select the menu tab which will add File Edit View Favorites Tools and Help
Click on the tools at the bottom of the drop down list will be internet options or Click start control panel internet options you will see a home page box To Create Page Tabs type
each adress on its own line (type in google.com) or your preferred home page and browser below that will be change search defaults click on settings you will see all search Providers
Toolbar extensions and Accelerators you have if don't need any of them you can disable or remove them

Create the menu tab on your Homepage right click in the top toolbar (Top of Screen) you should see a number of toolbar options select the menu tab which will add File Edit View Favorites Tools and Help
Select tools then from the tools drop down list select managed add ons toolbar extensions you have if don't need any of them you can disable or remove them.

Click start type cmd press enter you will be in DOS mode
type in ipconfig press enter
you will see all of your internet connection details

or type in your default gateway adress into your internet search should read something like 10.0.0.138 to get an inertnet connection
0helpful
1answer

IE command bar missing customize on View/Toolbar menu

Create the menu tab on your homepage right click in the top toolbar you should see a number of toolbar options select the menu tab which will add File Edit View Favorites Tools and Help Click on the tools at the bottom of the drop down list Managed add ons Toolbar extensions Search providers and Accelerators you have if don't need any of them you can disable or remove them. Right click in the bottom toolbar (Bottom of Screen) select the toolbars option then Desktop this will add >> arrows in the bottom toolbar select the arrows you will see a list with control panel which has another list of all control panel items

Create Menu tab right click in the top of screen (toolbar) you will see a number of toolbar options select the menu bar. This will add to your screen toolbar File Edit View Favorites Tools and Help select the view from the drop down list will be a Zoom with percentages %
and text s largest to smallest b> b> Right click the toolbar at the bottom of your screen. Click "Properties." Check the "Auto-Hide" option. Click "Apply." This will minimize your toolbar. To reveal your toolbar again, move your mouse down to the bottom of your screen. This will reveal the toolbar for as long as your mouse is in this location.
0helpful
1answer

I want to change my homepage from yahoo to google

Create the menu tab on your homepage right click in the top toolbar you should see a number of toolbar options select the menu tab which will add File Edit View Favorites Tools and Help
Click on the tools at the bottom of the drop down list will be internet options or Click start control panel internet options you will see a home page box To Create Page Tabs type
each adress on its own line (type in google.com) or your preferred home page and browser below that will be change search defaults click on settings you will see all search Providers
Toolbar extensions and Accelerators you have if don't need any of them you can disable or remove them

Create the menu tab on your Homepage right click in the top toolbar (Top of Screen) you should see a number of toolbar options select the menu tab which will add File Edit View Favorites Tools and Help
Select tools then from the tools drop down list select managed add ons toolbar extensions you have if don't need any of them you can disable or remove them.
0helpful
1answer

Uninstall iminent internet

Create Menu tab right click in the top of screen (toolbar) you will see a number of toolbar options select the menu bar This will add to your screen toolbar File Edit View Favorites Tools and Help Select Tools tab then from the drop down menu Mange Add - Ons you will see Toolbar Extensions Search Providers Accelerators and Tracking protection You can remove or disable them right click on them select disable or remove some don't have the option to remove
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
1answer

Search options in drop down menu

It is possible. But you need to write a macro to map the selected item number to price.
0helpful
1answer

Writing bottable disk

Here are the instructions, taken right out of Nero's manual for Burning ROM 8. page 42:

9.3 Creating and Burning a Bootable Disc
To create a bootable disc, proceed as follows:
1. Click on the New button in the main Nero Burning ROM screen.
�� The New Compilation window is opened.
2. If you want to create a bootable CD, select the entry CD from the combo box and the entry
CD-ROM (Boot) from the list box. If you want to create a bootable DVD, select the entry
DVD from the combo box and the entry DVD-ROM (Boot) from the list box.
�� The tabs for the bootable disc are displayed; the Boot tab is in front.
3. If the template data for the bootable disc should originate from a logical drive:
1. Select the Bootable logical drive option button in the Source of boot image data area.
2. Select the entry you want from the drop-down menu.
If the logical drive you want does not appear in the drop-down menu, the reason for this is
that the drive is bigger than the space available on the disc. Please note that for operating
systems as of Microsoft® Windows® 2000 you need to have administrator rights in order to
be able to access drives directly, which you will need to do if you are to create bootable
discs.
4. If the template data for the bootable disc should originate from an image file:
1. Select the Image file option button in the Source of boot image data area.
2. Click on the Browse button and select the desired image file.
3. Select the language that should appear while the system is booting from the Boot locale
drop-down menu.
4. Check the Enable expert features box and select the emulation type for the image file
from the Emulation type drop-down menu.
5. Select any other options required on the tabs (see New Compilation Window).
6. Click on the New button.
�� The selection screen is displayed.
7. Select the files/folders that should be written to the ISO part of the bootable disc and drag
them into the compilation area.
�� The files/folders are displayed in the compilation area and the capacity bar indicates how
much storage space is required on the disc.
�� You have now created the bootable disc and can start the burn process (see Starting
the Burn Process).
Not finding what you are looking for?

72 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...