When analyzing complex amounts of data in Google Sheets, you can take advantage of its built-in sorting function to organize data. You can sort by individual columns or, for more complex data, you can sort by multiple columns.
To do this, you need to open your Google Sheets spreadsheet and select the amount of data you want to sort. You can do this manually by selecting the cells with the mouse or by selecting one of the cells in your data set and pressing Ctrl + A on the keyboard.
RELATED: Google Sheets Beginner̵7;s Guide
Once your data is selected, on the Google Sheets menu, click Data> Sort Range.
By default, Google Sheets offers only one column to sort by. To add more columns to your sort options, select the “Add another sort column” button.
When you sort by multiple columns in Google Sheets, sorting will take place from top to bottom. For example, a sample spreadsheet has product sales data with product names, sales dates, and prices displayed.
If you want to sort this information by name and then by the amount sold, you want to first select the product name column in column A (named “Product”) and the amount sold in column C (named “Price”) second.
You can sort this in ascending order, starting with product name near the beginning of the alphabet at the top, then with prices sorted by the minimum amount. Select “AZ” to sort this way or “ZA” to sort in descending order instead.
You can also mix and match these options. In this example, you can sort in ascending order of product name and descending order of sales amount.
When your sorting options are set, select the “Sort” button to sort your data. The information in your spreadsheet will be rearranged according to the rules in the “Sort intervals” option box.
For this example, the information above has been sorted by product name and prices in ascending order. This is clearly shown with the monitor and mouse products.
Priced at $ 100, the screen would come in second place if the sorting was performed only in the “Price” column (column C). However, since the sorting was performed first in the “Product” column (column A), the sold monitor was placed in front of the mouse.
You can undo one of these types by performing a different sort on your data set, by pressing the “Undo” button in the menu bar or by pressing Ctrl + Z on the keyboard.
RELATED: All the best keyboard shortcuts for Google Sheets