# How to Alphabetize in Google Sheets (Step-by-Step)

Google Sheets has some useful tools that you can use when working with data.

There are multiple ways you can use to alphabetize data in Google Sheets (i.e., sort data in alphabetical order in Google sheets). You can also use these same methods when you want to sort data based on the numerical value or date.

So, let’s get started

## Alphabetize Data Using the SORT function

With the SORT function in Google Sheets, you can easily alphabetize a single column and multiple columns data.

### Alphabetizing a Single Column Data

Suppose you have a dataset as shown below and you want to quickly alphabetize this single-column data in an ascending order (A to Z). Below is the formula that will sort this data alphabetically in an ascending order (A to Z):

`=SORT(A2:A12)` While the SORT function can take more arguments, if you want to quickly sort a single column data alphabetically (A to Z), you just need to give that range as the argument in the formula.

Also, note that the result of this SORT formula is an array. It occupies the same range size as that of the input range. Once you have used this formula, you won’t be able to change any part of the array.

For example, if you want to delete one single cell from the result, you won’t be able to do it. You can delete the entire formula result, but not just one cell value.

In case you want to change a part of the result, you can first convert the formula result to values and then make the changes.

In case the cell (where the resulting data is to appear) is already filled, the formula will give you an error.

One of the best parts about using a formula to alphabetize data in Google Sheets is that the resulting data is dynamic. This means that if you change any cell in the original dataset, the resulting data would automatically adjust the sort and give you the updated result.

### Alphabetizing Multiple Columns Data

In case you have a dataset where there are more than one column, you can still use the SORT function to alphabetize data based on one of the columns.

For example, suppose you have a dataset as shown below and you want to sort this entire dataset alphabetically using the country names. Below formula can do this:

`=SORT(A2:B11,1,FALSE)` The above formula takes three arguments:

• range: the range that you want to sort. Select all the columns here that you want to sort
• sort_column: The column based on which you want to sort. In this example, it’s the second column which has the GDP numbers
• is_ascending: TRUE if you want the sorting to be ascending and FALSE if you want it to be descending. We have chosen FALSE as we want the highest GDP country at the top.

## Alphabetizing Data Using In-Built Sort Options

The SORT function covered above gives you the dynamic result, which is linked to the original dataset and changes if the original data changes,

In case you just want to alphabetize the data and get static value, you can use the in-built sorting options in Google Sheets.

Suppose you have the dataset as shown below and you want to alphabetize this data (A to Z): Below are the steps to alphabetize this data in Google Sheets:

1. Select the entire column
2. Click the Data option in the menu 3. Click on the ‘Sort range’ option 4. In the Sort Range dialog box, click on the option ‘Data has header row’. In case your data doesn’t have a header row, you can keep this unchecked. 5. In the ‘Sort by’ drop-down, make sure the correct header is selected (in this example, since we only have one column, that header is selected by default) 6. Select the Sort criteria as A to Z 7. Click on Sort. The steps above would instantly sort the data alphabetically from A to Z.

In case you have multiple columns and you want to alphabetize the entire dataset based on one column, you can do that as well.

Suppose you have the data set as shown below and you want to sort this data alphabetically (by country names).

Below are the steps to alphabetize this dataset:

1. Select the entire dataset (including the headers)
2. Click the Data option in the menu
3. Click on the ‘Sort range’ option
4. In the Sort Range dialog box, click on the option ‘Data has header row’.
5. In the ‘Sort by’ drop-down, make sure the correct header is selected (in this example, select the Country column) 6. Select the Sort criteria as A to Z 7. Click on the Sort button. The above steps would instantly sort the entire dataset alphabetically based on the country names.