How to Sort in Google Sheets? (step by step guide)

Google Sheets is one of the most popular spreadsheet packages and there were numerous advanced features were embedded within this spreadsheet package. In this article, I am going to talk about one of these advanced features. Here, I am going to explain to you how to sort in google sheets? so please read the full article and follow the mentioned steps.


So, how to sort in google sheets? there were two ways to use this option. One is directly by just using the data tab and another way by declaring the functions. However, to apply to the sort option quickly within your sheets just open the google sheets and go to the Data tab and click on the sort range option and selects the sorting format, and click on the sort option. In the below section I have discussed these features in detail by using images, so read the entire article here.

What is Sorting?

Generally sorting is a kind of method or process in which data are sorted into any particular manner. You can use the sort features to sort any kind of data, such as to sort the numbers, to sort the dates, to sort the names, and other things as well.


However, within google sheets, you can access the sorting option very easily. To access that feature just clicks on the data tab and sort range option. Amongst all the spreadsheets packages google sheets provide a much better sorting option and being open-source web-based software, it is very much useful for the users.

How to Sort in Google Sheets by Using Data Tab?

Here i provide a step by step guide about how to apply the sorting option in google sheets without using any functions-

Step 1:

In the first step just open your google spreadsheets documents and here create any kind of data table in which you will apply the sorting options.

Here i provide an example about how i create a simple data table, just create a simple data table like this-

how to sort in google sheets

After creating this kind of simple data table just selects the full data because without selecting it you will be unable to apply the sorting option.

Step 2:

In the next step just click on the data tab and after clicking there numerous options will appears in front of you and from here you have to choose the sort range option.

how to sort in google sheets

Step 3:

After clicking on the sort range option various other options will appear, and from here you just have to select the sort option to apply to sort within your documents.

how to sort in google sheets

In this manner you can easily apply the sorting options within your google sheets documents.

However, here you will also get the other features like-

Data has Header Row:

If your data table is including with the header options then you can select this option, and after selecting this option google sheets will understand the facts that your data table is included with a header row and it will separate your main data table with a header row.

Sort By:

This option is used to declare the facts in which columns you want to apply the sorting option. In my data table I just only have three columns and here I can specify in which column I want to apply the sorting options.

Just, remember one thing that if your data table has more than three columns then it will definitely display more columns.

A – Z:

This option is mainly used to describe that in which format you want to apply the sorting options within your documents. And if you select this option the data will be sorted in the format of A- Z or ascending to descending.

Z – A:

This option is almost similar to the previous option and from here you can declare the data from the descending to ascending order.

Add another Sort Column:

From this section, you can apply another sort column within your documents, and with the help of that column, you can perform the sorting within two columns simultaneously.

Sort and Cancel:

These are the two basics buttons provides at the bottom of your documents and here by clicking on the sort options you can sort any kind of data table in any format.

And besides that, the cancel button is given, and by clicking on the cancel button you can cancel any kinds of things which you just have selected.

In this manner, by using these features you can easily apply the sorting options within your google sheets documents.

How to Sort in Google Sheets by Number?

To apply any kinds of number sorting within your documents you have to follow the same step that I have mentioned in the upper section.

But till here i have explained the steps-

Step 1:

In the first step open your google sheets documents and after that create a data table in which you want to apply sorting options. Make sure one thing that your data table must have included with the numbers.

how to sort in google sheets

Here, you will noticed the income section and there i will apply my number sorting option, just wait and watch.

Step 2:

Now in the next step just selects the full data table and click on the data tab and click on tha sort range option.

Step 3:

As, you have already noticed that my data table has three columns and within the third column or in the income column I will apply the sorting, and to perform that task I have to choose the number column from sort by options.

how to sort in google sheets

And after that simply click on the Z- A to option and sort option to get the results.

And here is the output-

how to sort in google sheets

Here the results come from ascending to descending order, such as BidYut’s incomes is most and therefore he is at the top of the lists and Rakesh incomes is lower they everyone, therefore, he is at the bottom of the lists.

How to Sort in Google Sheets by Dates?

Google Sheets also allows us to sorts the data in the data table in the format of dates and to do that you just have to follow some steps, such as-

Step 1:

Open the google sheets within your device and creates a data table and make sure that the data table must include some dates.

Step 2:

After creating the data table next selects the data table and go to the data tab options within google sheets, and after that select the sort range options.

Step 3:

After clicking on the sort range options next selects the data has header row option if your table has the header after that choose the format in which you want to apply the sorting and then click on the sort option, you will be noticed that the data were formatted according to your instructions.

How to Sort in Google Sheets by Name?

Yes, you can definitely sort any kinds of names within google sheets, and to do that you have to follow the same process, till I have explained here the steps-

Step 1:

In the first step open the google sheets and create a database which consists with some names.

Step 2:

After that go to the data tab option and choose the data range options from here.

Step 3:

Now selects the data has header row option and after that selects the sort by option and selects the format in which you want to sort your google sheets(A-Z or Z-A) and click on the sort option.

In CloClusion:

This article is all about how to sort in google sheets? and by applying this method you can easily sort any kind of data in google sheets such as numbers data, date, names, columns, etc.

I hope you have liked this article and if you have any kind of query then you can ask me in the comment section and please follow our website regularly for this kind of informational and helpful article.

Also Read