Excel下拉列表：快速选择？ [英] Excel Drop-down lists: quick select?

问题描述

我有一个Excel文档，将项目从另一个xls作为列表项来填充下拉菜单。问题是，有很多选择。我找不到快速去我想要的地区的方法。 （例如，打开下拉列表并按b不会像大多数正常下拉菜单那样转到B）。

I have an Excel document pulling items from another xls as list items to populate a drop-down menu. The problem is, there are a LOT of choices. I can't find a way to quickly go to the area I want. (e.g. opening the drop-down list and pressing "b" doesn't go to the B's as it does for most normal drop-downs)

这可能吗？或者有一些方法可以在用户开始输入文件后自动完成下拉列表？

Is this possible? Or is there some way to autocomplete the drop-down once the user starts typing into it?

推荐答案

转到工具>选项 - 编辑并选中启用自动完成单元格

Go To Tools>Options - Edit And Check Enable AutoComplete For Cell

值移动您的列表中的项目正好在

Values Move Your List Of Items Is In The Range Immediately Above The

验证单元格。隐藏您的验证单元之上的行。

Validation Cell. Hide The Rows Above Your Validation Cell.

从这里取得：

http://www.ozgrid.com/Excel/autocomplete-validation.htm

这篇关于Excel下拉列表：快速选择？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！