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
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.
Here's a link to this great service
Posted on Jan 02, 2017
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
Tips for a great answer:
Jan 28, 2016 | Amazon Kindle Fire HD
May 27, 2014 | Microsoft Excel 2010
Aug 14, 2013 | Microsoft Office Computers & Internet
Jan 23, 2013 | Western Digital Corporation WD ShareSpace...
Keyboard shortcut You can also press CTRL+C.
Keyboard shortcut You can also press CTRL+V.
Mar 09, 2011 | Individual Software Professor Teaches Word...
Nov 15, 2010 | Microsoft Windows XP Professional
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
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
141 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: