Excel 2010中，如何使用键盘快捷键过滤下拉列表复选框? [英] Excel 2010, how to keyboard shortcut to filter dropdown checkboxes?

问题描述

对于Excel 2010，当我打开过滤器下拉菜单

For Excel 2010, when I have the filter drop-down open

...如何通过键盘快捷键进入过滤器"复选框部分?从从A到Z的排序"跳到搜索"框，一直到复选框.

...how do I get to the filter checkbox section via keyboard shortcut? Skipping everything from "Sort A to Z" to the "Search" box, going all the way to the checkboxes.

推荐答案

最快的选项: e  ↓ 

在Excel 2010(英语)中，您只需按 e 即可进入过滤器文本框；从那里，您可以使用向下箭头键↓转到第一个复选框:

Quickest Option: e  ↓  

In Excel 2010 (English) you just have to press e to get to the filter textbox; from there you can use the down arrow key  ↓   to go to the first checkbox:

Shift + Tab

Shift + Tab

Shift + Tab

(如@Sean_Cheshire所述)-从取消"和确定"的第一个条目向后"移到第一个(非常好！)复选框.

(as mentioned by @Sean_Cheshire) - this goes "backwards" from the first entry over "Cancel" and "OK" to the first (sic!) checkbox.

上面的问题是关于如何在过滤器下拉列表内移动 的.要打开过滤器下拉菜单，您有一个或两个选项:

The question above is about how to move inside the filter drop-down. To open the filter drop-down, you have one or two options:

• 对于任何过滤器:正如@Juhi和@Josh所指出的那样，您可以在列标题单元格(单击以打开下拉菜单时，使用键盘打开该菜单， (向下))，方法是输入 Alt + ↓↓.

• For any filter: As @Juhi and @Josh have pointed out, you can open said menu with the keyboard when the column heading cell (where you would click to open the drop-down) is selected by typing Alt+ ↓  .

用于表:如果您使用的是

For tables: If you are using a Table object instead of a pivot table or regular filtered range, you can be in any row of the Table and open the filter drop-down using Alt+Shift+ ↓  

这篇关于Excel 2010中，如何使用键盘快捷键过滤下拉列表复选框?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！