{"id":89970,"date":"2020-10-15T13:24:00","date_gmt":"2020-10-15T10:24:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-sort-by-multiple-columns-in-google-sheets\/"},"modified":"2020-10-15T13:24:00","modified_gmt":"2020-10-15T10:24:00","slug":"how-to-sort-by-multiple-columns-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-sort-by-multiple-columns-in-google-sheets\/","title":{"rendered":"#How to Sort by Multiple Columns in Google Sheets"},"content":{"rendered":"

“#How to Sort by Multiple Columns in Google Sheets”<\/strong><\/p>\n

\n\"Google<\/p>\n

When you\u2019re analyzing complex data sets in Google Sheets, you can take advantage of its built-in sorting feature to organize the data. You can sort by individual columns or, for more complex data, you can sort by multiple columns.<\/p>\n

To do this, you\u2019ll need to open your Google Sheets<\/a> spreadsheet and select the data set you wish to sort. You can do this manually by selecting the cells using your mouse, or by selecting one of the cells in your data set and pressing Ctrl+A on your keyboard.<\/p>\n

RELATED:<\/strong> The Beginner’s Guide to Google Sheets<\/em><\/strong><\/p>\n

Once your data is selected, click Data > Sort Range from the Google Sheets menu.<\/p>\n

\"To<\/p>\n

In the \u201cSort Range\u201d option box, you can select how you wish to sort your data.<\/p>\n

You can select the column to sort by, as well as whether to sort in ascending or descending order. Click the \u201cData Has Header Row\u201d to be able to select columns by the header cell.<\/p>\n

\"Click<\/p>\n

By default, Google Sheets will only offer one column to sort by. To add multiple columns to your sort options, select the \u201cAdd Another Sort Column\u201d button.<\/p>\n

\"Press<\/p>\n

When you sort by multiple columns in Google Sheets, the sort will take place in order from top to bottom. For instance, an example spreadsheet has product sales data with product names, sale dates, and prices shown.<\/p>\n

If you wanted to sort this data by name and then by the amount sold, you\u2019d want to select the product name column in column A (named \u201cProduct\u201d) first and the amount sold in column C (named \u201cPrice\u201d) second.<\/p>\n

\"A<\/p>\n

You could sort this in ascending order, starting with product names near the start of the alphabet at the top, then with prices sorted by the smallest amount. Select \u201cA-Z\u201d to sort this way or \u201cZ-A\u201d to sort in descending order instead.<\/p>\n

You can mix and match these options, too. For this example, you could sort in ascending order for product names and descending order for sales amounts.<\/p>\n

\"In<\/p>\n

Once your sorting options are set, select the \u201cSort\u201d button to sort your data. The data in your spreadsheet will be rearranged following the rules set in the \u201cSort Range\u201d options box.<\/p>\n

\"An<\/p>\n

For this example, the data above has been sorted with product names and prices both in ascending order. This is shown clearly with the monitor and mouse products.<\/p>\n

Priced at $100, the monitor would come second if the sort was only performed on the \u201cPrice\u201d column (column C). As the sort was performed on the \u201cProduct\u201d column (column A) first, however, the sold monitor was placed ahead of the mouse.<\/p>\n

\"Examples<\/p>\n

You can undo any of these sorts by performing another sort on your data set, by pressing the \u201cUndo\u201d button in the menu bar, or by pressing Ctrl+Z on your keyboard.<\/p>\n

RELATED:<\/strong> All the Best Google Sheets Keyboard Shortcuts<\/em><\/strong><\/p>\n<\/div>\n