本文教你如何在谷歌表格中根据某列对两列或多列数据进行排序。
步骤
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/1e\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-1-Version-3.jpg\/v4-460px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/1\/1e\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-1-Version-3.jpg\/v4-728px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
打开“谷歌表格”。在浏览器中前往https://sheets.google.com,然后点击电子表格。
- 如果你想创建一个新的电子表格,那就点击页面左上角的空白。
- 如果你还没有登录谷歌帐户,系统会提示你先用谷歌电子邮件地址和密码登录。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/70\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-2-Version-3.jpg\/v4-460px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/70\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-2-Version-3.jpg\/v4-728px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
选择要排序的列。点击并拖动鼠标,从某列的顶部单元格一直拖动到另一列的底部单元格。[1]
- 要排序的列必须相邻。
- 如果你打开了一个新的电子表格,在继续之前输入数据。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/b\/bb\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-3-Version-3.jpg\/v4-460px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/b\/bb\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-3-Version-3.jpg\/v4-728px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
点击数据。这个标签在表格的顶部。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/16\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-4-Version-3.jpg\/v4-460px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/1\/16\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-4-Version-3.jpg\/v4-728px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击对范围排序。你可以在下拉菜单的中间看到这个选项。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/e2\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-5-Version-3.jpg\/v4-460px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/e2\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-5-Version-3.jpg\/v4-728px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
选择要排序的列。点击“排序依据”右边的下拉框,然后选择一个列作为排序依据。
- 例如:如果姓名在“A”栏,工资在“B”栏,你可以选择“A”栏按姓名排序,而“B”栏按金额排序。
- 如果所选的列在第一个单元格中有标题,还要选中“数据具有标题行”框。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/3\/35\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-6.jpg\/v4-460px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-6.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/3\/35\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-6.jpg\/v4-728px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
选择一种顺序。你可以点击A → Z,选择升序(按字母/数字顺序),或者点击Z → A,按降序排列。
- 如果你想添加另一个排序方法,点击+添加其他排序列链接。你可以通过点击方法左侧的x来删除额外的排序方法。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/5\/52\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-7.jpg\/v4-460px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-7.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/5\/52\/Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-7.jpg\/v4-728px-Sort-by-Multiple-Columns-in-Google-Spreadsheets-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
点击排序。这样就会根据你选择的列对所有选择的数据进行排序。
小提示
- 升序排列数字从最小到最大(1,2,3),降序排列数字从最大到最小(3,2,1)。
警告
- 如果要排序的两列之间有一个空列,则排序范围选项将变灰。