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:

• Sort sheet by column
• Sort range by column
• Sort range

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.

Bulbasaur 318 Ivysaur 405 Venusaur 525 Charmander 309 Charmeleon 405 Charizard 534 Squirtle 314 Wartortle 405 Blastoise 530 Caterpie 195 Metapod 205 Butterfree 395 Weedle 195 Kakuna 205 Beedrill 395 Pidgey 251 Pidgeotto 349 Pidgeotto 479 Rattata 253 Raticate 413

Copy Values

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

2. 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.