You are viewing the article How to Sort Multiple Columns on Google Sheets at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 1,197 times.
This wikiHow teaches you how to sort two or more columns of data based on certain columns on Google Sheets (Google Sheets).
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1e/Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-1-Version-3.jpg/v4- 728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-1-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/1e/ Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-1-Version-3.jpg/v4-728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-1-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open Google sheet. Go to https://sheets.google.com in your browser and click on the spreadsheet.
- If you want to create a new sheet, click Blank in the upper left of the page.
- If you’re not signed in to your Google account, you’ll be prompted to sign in with your Google email address and password first.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/70/Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-2-Version-3.jpg/v4- 728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-2-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/70/ Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-2-Version-3.jpg/v4-728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-2-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the columns you want to sort. Click and drag the mouse from the top cell in the first column down to the last cell in the other column. [1] X Research Source
- The columns that you want to sort must be next to each other.
- If you create a new worksheet, you’ll need to enter the data before continuing.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/bb/Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-3-Version-3.jpg/v4- 728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-3-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/bb/ Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-3-Version-3.jpg/v4-728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-3-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Data . This tab is at the top of the sheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/16/Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-4-Version-3.jpg/v4- 728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-4-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/16/ Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-4-Version-3.jpg/v4-728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-4-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Sort range . This option is in the middle of the drop-down menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e2/Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-5-Version-3.jpg/v4- 728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-5-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e2/ Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-5-Version-3.jpg/v4-728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-5-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the column to sort. Click the drop-down box to the right of “sort by”, then select the column to use as the basis for sorting.
- For example, if you have a list of names in column “A” and salaries in column “B”, you need to select column “A” to sort by name and column “B” if you want to sort by salary.
- If the selected columns have headers in the first cell, check the “Data has a header row” option here.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/35/Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-6.jpg/v4-728px-Sort- by-Multiple-Cpumns-in-Google-Spreadsheets-Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/35/Sort-by-Multiple-Cpumns- in-Google-Spreadsheets-Step-6.jpg/v4-728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-6.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select order. You can select ascending (alphabetical/numeric) order by clicking A → Z , or choose Z → A to sort in descending order.
- If you want to add another sort, click the link + Add another sort cpun (Add another sort column). You can remove unnecessary sorting by clicking the x to the left of the method.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/52/Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-7.jpg/v4-728px-Sort- by-Multiple-Cpumns-in-Google-Spreadsheets-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/52/Sort-by-Multiple-Cpumns- in-Google-Spreadsheets-Step-7.jpg/v4-728px-Sort-by-Multiple-Cpumns-in-Google-Spreadsheets-Step-7.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Sort . All selected data will be sorted by base column.
Advice
- Ascending order will sort numbers from smallest to largest (1, 2, 3), and descending order will sort numbers from small to large (3, 2, 1).
Warning
- If there are many empty columns between the two columns that you want to sort, the Sort range option will be disabled.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 1,197 times.
This wikiHow teaches you how to sort two or more columns of data based on certain columns on Google Sheets (Google Sheets).
Thank you for reading this post How to Sort Multiple Columns on Google Sheets at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: