Sorting Range

Hello, in this chapter we will cover the topic of Sorting Range. You will learn how to effectively sort data in a table in ascending or descending order, which will help you better organize your information. This is especially useful when working with large spreadsheets or when you need to sort data by one or more columns at once, using advanced sorting options.

Executing Sort

• Highlight the range of data you want to sort (the entire sheet in our case);
• Go to Data → Sort range → Advanced range sorting options.

Configuring Sort Parameters

• Check the box next to Data has header row;
• Sort by: choose the column you want to sort by (for example, Overall Rating, which corresponds to column C);
• Sort order:
  • A → Z — for ascending order (for numbers, from smallest to largest);
  • Z → A — for descending order (for numbers, from largest to smallest);
• Add another sort column: add another column for sorting (for example, first by Seat Comfort, and then by Overall Rating).

Example of Use

Open our spreadsheet with airline ratings data.

Go to Data → Sort range → Advanced range sorting options.

• Sorting by poor airline ratings:
  • Select the Overall Rating column;
  • Set the Sort order to A → Z;
• Sorting by the number of reviews with good seat comfort:
  • Add the Seat Comfort column for additional sorting;
  • Set the Sort order for both columns to Z → A.

Now, the data is first sorted by the highest seat comfort rating and then by the lowest flight experience ratings. We did this to find an unusual pattern.