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?
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 Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 28, 2016 | Amazon Kindle Fire HD
Aug 14, 2013 | Microsoft Office Computers & Internet
Feb 04, 2012 | Microsoft EXCEL 2004 for Mac
Nov 15, 2010 | Microsoft Windows XP Professional
Jul 22, 2010 | Intuit QuickBooks: Pro 2005 for PC
Nov 03, 2009 | Intuit QuickBooks Pro 2008: Windows
Mar 16, 2009 | Adobe Computers & Internet
May 31, 2008 | NEC VT470 Multimedia Projector
Feb 27, 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
85 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: