在 Microsoft Excel 数据表中创建下拉列表通常可以提高数据输入效率,同时将数据输入的范围限定到特定项目的集合,或仅限于下拉列表中所提供的数据。按照以下步骤,学习如何在 Excel 2013 和早期版本中创建下拉列表。
步骤
方法 1Excel 2013
![](/static/upload/image/20220506/21243550.jpg)
![](/static/upload/image/20220506/21243551.jpg)
![](/static/upload/image/20220506/21243552.jpg)
![](/static/upload/image/20220506/21243553.jpg)
![](/static/upload/image/20220506/21243554.jpg)
![](/static/upload/image/20220506/21243555.jpg)
![](/static/upload/image/20220506/21243556.jpg)
![](/static/upload/image/20220506/21243557.jpg)
![](/static/upload/image/20220506/21243558.jpg)
![](/static/upload/image/20220506/21243559.jpg)
![](/static/upload/image/20220506/21243560.jpg)
![](/static/upload/image/20220506/21243561.jpg)
![](/static/upload/image/20220506/21243562.jpg)
![](/static/upload/image/20220506/21243563.jpg)
![](/static/upload/image/20220506/21243564.jpg)
方法 2Excel 2010、2007 和 2003
![](/static/upload/image/20220506/21243565.jpg)
![](/static/upload/image/20220506/21243566.jpg)
![](/static/upload/image/20220506/21243567.jpg)
![](/static/upload/image/20220506/21243568.jpg)
![](/static/upload/image/20220506/21243569.jpg)
![](/static/upload/image/20220506/21243570.jpg)
![](/static/upload/image/20220506/21243571.jpg)
![](/static/upload/image/20220506/21243572.jpg)
![](/static/upload/image/20220506/21253573.jpg)
![](/static/upload/image/20220506/21253574.jpg)
![](/static/upload/image/20220506/21253575.jpg)
![](/static/upload/image/20220506/21253576.jpg)
![](/static/upload/image/20220506/21253577.jpg)
![](/static/upload/image/20220506/21253578.jpg)
![](/static/upload/image/20220506/21253579.jpg)
![](/static/upload/image/20220506/21253580.jpg)
小提示
在键入下拉列表中所列表项目时,请按您希望其在下拉菜单中所显示的顺序键入。例如,按字母顺序键入条目,使用户更容易查找特定项目或值。完成下拉列表创建后,请打开并查看下拉列表,确保输入的所有项目已恰当显示。在某些情况下,您可能需要拉宽单元格以全部显示所有项目。警告
如果数据表被保护或共享,或链接到“SharePoint”网站,则将无法访问“数据有效性”菜单。如果您的数据表存在上述任意情形,则请移除保护、取消共享,或从“SharePoint”网络取消链接,然后再次尝试访问“数据有效性”。
标签:
暂无标签