来自单个单元格CSV的Google表格数据验证下拉菜单 [英] Google Sheets Data Validation dropdown from single cell CSV

问题描述

是否有一种方法可以通过单个单元格中的CSV字符串创建数据验证下拉列表?我知道如何创建数据验证下拉菜单并手动输入这些项目，但是我希望能够引用包含所有项目的CSV字符串的单元格来创建下拉菜单.谢谢.

Is there a way to create Data Validation drop-down list from a CSV string located in a single cell? I know how to create data validation drop down and manually input those items, but I want to be able to refer to a cell with the CSV string of all items to create the dropdown. Thanks.

推荐答案

不幸的是，这在Google表格中尚无法实现.CSV值必须在单独的单元格中.另外，也不支持将公式用作范围输入.

unfortunately, this is not yet possible in Google Sheets. CSV values need to be each in a separate cell. also, formulae as range input are not supported either.

这篇关于来自单个单元格CSV的Google表格数据验证下拉菜单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！