Question about Microsoft Excel for PC
Help. I am putting drop down menus in my Excel worksheet which is working fine but on some of the options I need to "filter" what is given in other menus. For eg, First drop down gives option and depending on what option you choose, another drop down menu gives options. Say I choose "Not Applicable" in the first menu then I want the second menu to automatically put in "Not Applicable" to prevent something being chosen. Or, I choose and option in the first drop down and then the second drop down will automatically give me the choices available for that option (ie. colours).
Can you help?
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.
Posted on Apr 07, 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.
Posted on Apr 01, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
May 06, 2016 | Microsoft Excel Computers & Internet
Feb 11, 2015 | Computers & Internet
May 27, 2014 | Microsoft Excel 2010
Aug 14, 2013 | Microsoft Office Computers & Internet
Aug 26, 2009 | Microsoft Office Excel 2007
Apr 11, 2009 | Microsoft Office Excel 2003 for PC
Nov 05, 2008 | Microsoft Excel for PC
Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...
Feb 28, 2008 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
131 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: