Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

Google Sheets 排序


Google Sheets 排序

Google 表格具有用于按**升序**或**降序**排序数据的命令。

**升序**: 对于数字,从小到大排序;对于文本,按 A 到 Z 排序。

**降序**: 对于数字,从大到小排序;对于文本,按 Z 到 A 排序。

Google 表格具有以下排序命令

排序命令可以在**数据**菜单中找到。



示例

按宝可梦的总属性值升序排序(从小到大)。

复制以下值以进行操作。

复制值
  1. 通过点击列栏中的字母 B 选择列B

  1. 点击**数据**菜单,然后选择**按列 B 排序工作表,A → Z**

这是结果

现在所有宝可梦都按其总属性值排序了。

在下一章中,您将了解有关 Google 表格中**排序工作表**命令的更多信息。



×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
[email protected]

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
[email protected]

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookie and privacy policy.

Copyright 1999-2024 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.