Sort in Google Sheets

Small business owners use Google Sheets for multiple purposes. Whether it’s a customer database, product inventory, or employee payroll, Google Sheets can help you organize data quickly and easily. If you want to view the data in ascending or descending order, you can save a lot of time by learning how to sort in Google Sheets.

In this article, you’ll explore different ways to sort data in Google Sheets.

Let’s dive in:

Is there a sorting feature in Google Sheets?

Yes, Google Sheets has a sorting feature. The syntax to use a sort function in Google Sheets is mentioned below:

=SORT(range, sort column, is_ascending, [sort_column2, is_ascending2, …]†

In this formula, is_ascending – TRUE or FALSE specifies whether the date is sorted in ascending or descending order. True indicates that data is sorted in ascending order and False stands for descending order.

Sort by Google Sheets

For example, you want to sort the data in the third column of the table below:

Click in the cell where you want to sort the data, and then apply the formula =SORT(A2:C8, 3, True).

When you click enter, the data in the third column is sorted.

Ways to sort Google Sheets

There are multiple ways to sort data in Google Sheets.

Let’s explore:

Sort by date in Google Sheets

After selecting the entire table, click the Data tab. Then select the sort range menu. You will be presented with three options in the Sort Range dialog box. Choose advanced range sorting options.

Once you click on the advanced range sorting options, the following dialog box will open. Check the Data has header row box and select the date column from the Sort by menu. In this table, it is the Customer Meeting Date column that we want to sort.

Select the AZ option for ascending date sort order.

The moment you click the Sort button, the selected column is sorted (in ascending order) by date.

Google Sheets: Sort by Time

Select the entire data table and go to the Data menu. And then click Sort Range and choose the Advanced range sort options.

Make sure the data has a header and choose the column you want to sort. For this example, we chose the Time to Hold Customer Meet column. Select the AZ option for ascending sort order of time.

Click the Sort data button and the data will be sorted by time in the selected column.

Sort alphabetically in Google Sheets

Select the entire data table in the sheet and then click the Data menu. Scroll down and select the Sort Range tab.

You will see three options in the drop-down menu. Click on the Advanced sorting options for range.

Once you click on the advanced range sorting options, a new window will open. Verify that Data has a field with a header row, then choose the column you want to sort alphabetically. In this case, it’s the City column.

Select the AZ option for the ascending order and then click the Sort button.

The data in the City column is sorted in alphabetical order.

Sort by number in Google Sheets

The process of sorting your data by number in Google Sheets is the same as the process of sorting data alphabetically.

Select your data table and click the Data button. Select the sort range and go to Advanced range sort options.

Check Data has a header row field. And choose the column whose data you want to sort from the Sort by drop-down list. Choose the AZ option to sort the column’s data in ascending order.

Click the Sort button and the numerical data of the selected column will be sorted in ascending order.

Sort data by color in Google Sheets

Select the entire table and click on the Data. Then click on the Create a filter.

A filter icon appears on the header. Click the icon in the colored column and then select Sort by Color. You have options to sort by fill color or text color. Choose sort by fill color and choose the color. If you have colored text and want to sort the column by color, you need to sort by text color

We selected red to sort this column by red color.

Your colored column will be sorted as follows.

Sort multiple columns in Google Sheets

Select the entire data table and click the Data tab. Then select the sort range and choose the advanced sort options for the range from the drop-down list.

Check the Data has header box and choose the first column you want to sort. And then click Add another sort column to select the second column.

For example, we selected the City and Time to hold customer meeting columns to sort data. The process is the same to add more columns to sort data.

Select AZ for Ascending order.

Clicking the Sort button will quickly sort the data set in selected columns.

Sort rows in Google Sheets

There is no built-in horizontal sorting feature in Google Sheets. So you need to use the transpose function to sort a row in Google Sheets.

For example, you want to sort the following data horizontally.

Click the cell where you want to see sorted data.

Apply the formula =TRANSPOSE(SORT(TRANSPOSE(A1:F2),2)) to sort the second row.

When you hit enter, your second row will be sorted in descending order.

Automatic sorting in Google Sheets

If you want data in Google Sheets to be sorted automatically when you make a change, you’ll need to sort data using the sort feature.

Here is the dataset we sorted earlier in this article (third column) using the sort function:

Now make a change to the penultimate cell of the third column in the first table:

The data in the third column of the sorted table is automatically sorted.

Google Sheets Sorting Feature Used in Business

Businesses can use Google Sheets sorting features in many ways, such as:

You can carefully study critical data by viewing the numbers in ascending or descending order You can easily find underperforming products/employees by sorting data in ascending order You can learn more about your company and people by sorting data in multiple ways

Sorted data in Google Sheets can also save you a lot of time when trying to understand your critical data. This is because it is easy to understand the data by looking at the numbers in ascending or descending order.

Conclusion

Now that you know how to sort on Google Sheets. It’s time to start using this handy feature to help you decrypt your data. To fully utilize the power of Google Sheets, you should also learn how to create a Gantt chart in Google Sheets, how to create a line chart in Google Sheets, and how to create a bar chart in Google Sheets.

Image: Depositphotos


This post Sort in Google Sheets was original published at “https://smallbiztrends.com/2022/05/how-to-sort-in-google-sheets.html”

Leave a Reply

Your email address will not be published.