How to Auto Sort in Google Sheets(Quick & Easy Guide )

In this tutorial you will learn How to auto sort in Google Sheets

To Auto Sort data in Google Sheets you can use the SORT() function.

SORT function Sorts a given array’s or range’s rows according to the contents of one or more columns.

SORT function Syntax

`SORT(range, sort_column, is_ascending, [sort_column2, is_ascending2, ...])`

How to Auto Sort in Google Sheets : Step by Step Guide

Enclosed are the steps to Auto Sort Google Sheets:

Step 2 :Prepare your dataset

Open your Google Spreadsheet with dataset which you want to automatically sort in Google Sheets.

In this example we will use the below dataset

Step 3 :Use the SORT function

Now Select the cell where you need to display the sorted data and use the SORT function .

In our example we will use the below syntax on Cell D2

`=SORT(A2:B12)`

Step 4 : Press Enter and you will get the result in alphabetical order

To sort the data in reverse order from Z to A we can use the below formula

`=SORT(A2:B12,1,FALSE)`

How to Auto Sort in Google Sheets(Conclusion )

In the above tutorial we have provided your steps using which you can Auto Sort in Google Sheets.We hope this tutorial on How to Auto Sort in Google Sheets was useful.

Related articles :

How to Insert Spin Button in Google Sheets ( Easy Guide )

How to Freeze Rows in Google Sheets

How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)

How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )