See all How-To Articles

Put Things in Alphabetical Order in Excel & Google Sheets

This tutorial demonstrates how to put things in alphabetical order in Excel and Google Sheets.


sort things alphabetically


Sort List Alphabetically

Right-Click to Sort

In Excel, you can easily sort cells in a column alphabetically. Say you have the following list of products in Column B, and you want to sort them alphabetically.


sort things alphabetically


(1) Right-click anywhere in the data range (here, B1:B9), then (2) choose Sort and (3) Sort A to Z.


sort things alphabetically 1


As a result, cells in Column B are sorted alphabetically, from A to Z.


sort things alphabetically final


Sort From the Ribbon

Another way to do the same thing is to use the Sort & Filter option in the Home tab. Select any cell in the range you want to sort, and in the Ribbon, go to Home > Sort & Filter > Sort A to Z.


put thing in alphabetical order


The result is the same: All items are in alphabetical order.


sort things alphabetically final


Sort Alphabetically in Google Sheets

You can also sort a list in alphabetical order in Google Sheets. Select the data range you want to sort (B1:B9) and in the Menu, go to Data > Sort range by column B, A → Z.


google sheets sort things alphabetically


If you want to sort the whole column, you should choose the first option in the list (Sort sheet by Column B, A → Z).

As a result, all cells in the selected range are now sorted alphabetically.


google sheets sort things alphabetically final

See all How-To Articles