Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

Google Sheets Sort


Google Sheets Sorting

Google sheets has commands for sorting the data in Ascending or Descending order.

Ascending: from the smallest to the largest for numbers and from A to Z for text.

Descending: from the largest to the smallest for numbers and from Z to A for text.

Google sheets has the following sort commands:

The sort commands can be found in the Data menu.



Example

Sort the Pokemon by their total stats in ascending order (from smallest to largest).

Copy the values to follow along.

Copy Values
  1. Select column B by clicking on the letter B in the column bar

  1. Click on the Data menu and select Sort sheet by column B, A → Z

This is the result:

Now all the Pokemon are sorted by their total stats.

In the next chapter, you will learn more about Sort sheet command in Google sheets.