I hope this makes sense...I've got a fairly simple Excel spreadsheet, and though I'm not sure if this is even possible, what I'm trying to achieve is at the top of the sheet to have a row of 4 drop-down lists that users can use to filter the data in the spreadsheet.
我希望这是有道理的...我有一个相当简单的Excel电子表格，虽然我不确定这是否可能，但我想要实现的是在表格的顶部有一排用户可用于过滤电子表格中数据的4个下拉列表。
I want them to be able to select a criteria from a drop-down list of the column headings from the spreadsheet, and filter from values in that column, and a further 3 drop-downs, so they can filter data in the spreadsheet for up to 4 columns. In my head I'm thinking that it'd be a row of drop-downs, but thinking about it, it may need to be a two-stage process, first selecting the column heading and then the criteria to filter on for each of the possible 4 options (users wouldn't have to select 4 columns, but would need to be able to select up to 4 columns).
我希望他们能够从电子表格列标题的下拉列表中选择一个条件，并从该列中的值进行过滤，再过3个下拉菜单，这样他们就可以过滤电子表格中的数据了到4列。在我的脑海里，我认为它是一排下拉，但考虑到它，它可能需要一个两阶段的过程，首先选择列标题，然后筛选每个标题。可能的4个选项（用户不必选择4列，但需要能够选择最多4列）。
Basically, it's effectively recreating the Excel auto-filter in a different series of cells rather than at the top of each column (a couple of users have said that they feel that it would be more intuitive than searching for the little arrow on each column). I'd need the data to be filtered in place, rather than copied to somewhere else or displaying in a table or something.
基本上，它有效地在不同系列的单元格中重建Excel自动过滤器而不是在每列的顶部（有几个用户说他们觉得它比在每列上搜索小箭头更直观） 。我需要将数据过滤到位，而不是复制到其他地方或显示在表格或其他内容中。
Is this possible?
这可能吗？
(btw - my test spreadsheet I'm trying different things on at home on my home laptop is using Excel 2016, whereas at work where the 'live' spreadsheet is, because we're rather behind the times, Excel 2010, so it needs to work on both versions)
（顺便说一句 - 我的测试电子表格我在家里的笔记本电脑上尝试不同的东西是使用Excel 2016，而在'live'电子表格的工作中，因为我们落后于时代，Excel 2010，所以它需要在两个版本上工作）
1 个解决方案
#1
0
It is possible, depends on how you wanna do it. You are descriping the process you have to do. What you need are 4 dropdowns, you have to fill them with your criterias, here. When the user selects something you can apply autofiltersto the columns.
这有可能，取决于你想怎么做。您正在描述您必须执行的过程。你需要的是4个下拉菜单，你必须在这里填写你的标准。当用户选择某些内容时，您可以将自动过滤器应用于列。
#1
0
It is possible, depends on how you wanna do it. You are descriping the process you have to do. What you need are 4 dropdowns, you have to fill them with your criterias, here. When the user selects something you can apply autofiltersto the columns.
这有可能，取决于你想怎么做。您正在描述您必须执行的过程。你需要的是4个下拉菜单，你必须在这里填写你的标准。当用户选择某些内容时，您可以将自动过滤器应用于列。