如何制作一个下拉菜单，“同时编辑单元格”在Excel中列出？ [英] How to make a drop-down, "while-editing-cell" list in Excel?
问题描述
- SUM
- SUMIF
- SUMIFS
- SUBTOTAL
- SWITCH等。
如果您继续使用UM键入 - 只有该选项将保留：
- SUM
- SUMIF
- SUMIFS
我的问题是，是否有任何可能的方法（通过VBA或其他）将类似的下拉列表设置为另一个符号，如括号（ ）？所以当编辑单元格时键入括号（），具有某些选项的列表会出现，因此它会在您输入一些字母时缩小（并且其选项的整套设置为简单范围表单中的某个地方 - 像以前在数据验证中的 ）。而且我希望这样的列表每次发生时，我在编辑单元格时使用方括号。我该怎么做？
你可以做数据验证。
所以例如你有鞋子颜色。
您在电子表格
上创建一个区域，值为排序值，并创建一个命名范围（到公式左侧），其中向下三角形是。要做到这一点，选择具有值的单元格，然后在范围内输入颜色，确保返回/输入。
黑色
蓝色
棕色$ $ $ $ $ $ $ $ $％ > _
在另一个要从列表中选择颜色的单元格中，通过选择它来激活单元格（在我的例子中为A1）。
选择数据功能区选项卡，然后选择数据验证图标。
然后，您有一个下拉列表可供选择：
，你可以做些消息。在数据验证窗格中与其他选项卡进行比赛。
In Excel, as everyone knows, when you type "=" and follow with "S" - a drop-list of functions occures:
- SUM
- SUMIF
- SUMIFS
- SUBTOTAL
- SWITCH, etc.
And if you continue typing with "UM" - only theese options will left:
- SUM
- SUMIF
- SUMIFS
My question, is there any possible way (via VBA, or else) to set similar drop-list to another symbol, like brackets (")? So when you type brackets (") while editing a cell, a list with some options would occure and so its shrinks as you type some letters (and whole set of its options is set as simple range somewhere in a sheet - like it used to be in "data validation"). And I want such list to occure everytime I use brackets while editing a cell. How can I do that?
You can do things like Data validation.
So for example you have Shoe Colour.
You create an area on spreadsheet
with values sorted values, and create a named range (to left of formula), where up down triangle is. To do that select the cells with the values, then enter Colour into the range, being sure to hit return/enter.
Black
Blue
Brown
Maroon
In another cell where you want to select a colour from the list, make a cell active by selecting it (A1 in my case).
Select the Data ribbon tab, then Data validation icon.
Then in the settings select List from the drop down, and in the source place the formula =Colour You can make optional by checking allow-blank.
Then you have a drop down list to select from:
There are types other than 'list' too:
and you can do things like have messages. Have a play around with the other tabs in the Data Validation pane.
这篇关于如何制作一个下拉菜单，“同时编辑单元格”在Excel中列出？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
