I'm using a large validation list on which a couple of vlookup() functions depend. This list is getting larger and larger. Is there a way to type the first letters of the list item I'm looking for, instead of manually scrolling down the list searching for the item?I'm using a large validation list on which a co
阅读背景：
Excel 2010:如何在验证列表中使用自动完成。
来源：互联网
分享到：
