How to arrange alphabetical order in Google Sheets

When working with data sheets on Excel or Google Sheets, the word order rearrangement in alphabetical order will often be required. Especially when you work with the data table that contains the Name column, it is necessary to rearrange the name according to the alphabet.

Google Sheets also has the ability to rearrange words in alphabetical order. This makes the data sheet more intuitive, scientific and easier to see. The following article of Network Administrator will guide you how to rearrange words in alphabetical order on Google Sheets.

For example, I will proceed to rearrange the words in the Product column in alphabetical order.

How to arrange alphabetical order in Google Sheets Picture 1

Step 1:

First you need to black out the column to reorder the words. If you just need to rearrange a column, just black out the column. In the case that the column is related to other columns, we need to highlight those columns, to ensure the correct value for each line.

How to arrange alphabetical order in Google Sheets Picture 2

Step 2:

Next, select the Data item and select Sort range . We can also choose Sort sheet by column or Sort range by column. However, Sort range will have some other customizations for the data table.

How to arrange alphabetical order in Google Sheets Picture 3

Step 3:

Show small table Sort range form . Here if the data table has a header at the top, click Data has header row. Next in Sort by selecting the data column you want to reorder words, or you can leave it as confirmed by Google Sheets.

Next, select the word order A> Z or order Z> A. Here, alphabetically, we will select A> Z. Finally click the Sort button .

How to arrange alphabetical order in Google Sheets Picture 4

So the above data sheet has been rearranged in the alphabetical order in the Product column. The data that follows each value line in the Product will also be preserved.

How to arrange alphabetical order in Google Sheets Picture 5

So we rearranged the words in the Google Sheets data sheet by alphabetical list. Depending on the content of the table that the user delineates the data to be sorted, to avoid the case of upsetting data to follow each row when conducting the reordering.

I wish you all success!