Google Sheets is a wonderful interface that helps you to analyze and work with a large volume of data with ease. You can add as much data you want to your spreadsheet. But with increasing data, it becomes important for you to keep it organized. To make things easier, Google Sheets allow you to reorganize all your data by applying filters and sorting.
You can sort your data by arranging it numerically or alphabetically. Not just that, but you can also apply a filter to narrow down the data. You can even hide some of the data from view.
If you are someone who is working with Google Sheets for the first time and need help with sorting, you are in the right place. In this guide, we will tell you how to sort in Google Sheets. That being said, let’s walk you through the details.
Steps to sort in Google sheets:
- Open Google Sheets
- Highlight the group of cells you would like to sort:
- Do keep in mind that if your sheet includes a header row, then freeze it first.
- To freeze the row select the whole row by clicking on the number of rows, here we will freeze the first row:
- Now, navigate to View > Freeze and select “1 row”
- Next, the row will freeze
- To sort, click on Data > Sort range
- Now, the sorting pane will appear:
- Now, you can choose if the data has a header row and click on the check box. You can define which column you want to sort the sheet by(we will sort column A) and also how you want to sort either by A to Z(increasing) or Z to A(decreasing) order. Then, click on sort:
- Now, you can notice all your data sorted:
