Sorting by range, much like installing a filter, is a great way to quickly organize your data; both numerically and alphabetically. I will show you how to do so in just a few easy steps.
Step #1: Highlight the Cells
First, highlight the cells that you wish to sort and then open the “Data” menu.
Step #2: “Data”–>”Sort Range”
In the “Data” menu, select the option titled “Sort Range“. This will take you to a box that will help you sort your cells.
Step #3: Sort Your Cells
If you highlighted the header row as well, like I did, make sure you click that box. From here, you will be able to sort your selected columns in ascending or descending order.
- Numbers will be sorted from max to min (and Vice Versa).
- Letters and Words will be sorted alphabetically from A-Z (or from Z-A).
You also can add more columns to be sorted while you are still in the sorting box.
Step #4: Verify Success
As you can see, the column has successfully been alphabetized from A-Z, as was planned.
That is how you sort and break apart your cells in Google Sheets.