如何在Google电子表格中对数据验证输入列表进行排序 [英] How can you sort data validation input list in google spreadsheet

问题描述

鉴于以下数据验证设置，我只能按照在食物列表"列中输入食物的方式来选择食物.在我能够选择它们之前，有没有办法对它们进行排序?

Given the following data validation setup I can only select foods in the way I entered them in the list of foods column. Is there a way to sort these before I'm able to select those?

推荐答案

您可以使用数据透视表来帮助您:

You could use a PivotTable to help you:

1. 选择包含列表的字段，然后转到数据">数据透视表报告..."

1. Select the field containing the list and go to 'Data' > 'Pivot table report...'

单击行"的添加字段"，然后在下拉列表中选择字段.确保顺序升序，未选中显示总计"(否则，您将在验证中获得总计")，并且选项是在每次更改时更新表格:

Click 'Add field' for 'Rows' and pick the field in the dropdown. Ensure that the order is ascending, that the 'Show totals' is unchecked (or else, you'll get 'Grand Total' in your validation) and that the option is to update the table on each change:

注意:通常，您会在另一个工作表中获得数据透视表.您可以复制/粘贴该新工作表中的数据，并通过单击编辑范围..."来更改源数据，就像我在上图中所做的那样，然后删除初始工作表.

Note: You usually get the pivot table in a different sheet. You can copy/paste the data in that new sheet and change the source data by clicking on 'Edit range...' like I did in the picture above, then delete the initial sheet.

这篇关于如何在Google电子表格中对数据验证输入列表进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！