If you analyze complex data sets in Google Sheets, you can use the built-in sorting function to organize the data. You can sort by individual columns or, for more complex data, sort by multiple columns.
To do this, you need to open your Google Sheets spreadsheet and select the record you want to sort. You can do this manually by selecting the cells with your mouse or by selecting one of the cells in your dataset and pressing Ctrl + A on your keyboard.
CONNECTED: The beginner̵
Once your data is selected, from the Google Sheets menu, click Data> Sort Area.
By default, Google Sheets only offers one column for sorting. To add multiple columns to your sort options, select the “Add Another Sort Column” button.
When you sort by multiple columns in Google Sheets, the sorting is from top to bottom. For example, a sample table shows product sales data with product names, sales dates, and prices.
To sort this data by name and then by quantity sold, you must first select the Product Name column in Column A (labeled “Product”), then select the column in Column C (labeled “Price”).
You can sort this in ascending order, starting with product names at the beginning of the alphabet at the top, and then with prices sorted by the smallest amount. Select “AZ” to sort that way or “ZA” to sort in descending order instead.
You can mix and match these options too. In this example, you can sort by product name in ascending order and by sales amount in descending order.
Once your sorting options are set, select the “Sort” button to sort your data. The data in your spreadsheet will be rearranged according to the rules set in the Sort Area radio button.
In this example, the above data has been sorted with product names and prices in ascending order. This is evident in the monitor and mouse products.
At a price of USD 100, the monitor would be in second position if the sorting were only performed in the “Price” column (column C). Since the sorting was carried out first in the “Product” column (column A), the monitor sold was placed in front of the mouse.
You can undo any of these sorts by doing a different sort on your record, pressing the Undo button on the menu bar, or pressing Ctrl + Z on your keyboard.
CONNECTED: All the best Google Sheets keyboard shortcuts