In this article, we will show how to sort by last name in google sheets. Simply follow the steps below.
For the purpose of this demonstration, an example data sheet was created. Access this by clicking the link below to follow along:
Click here to open the sample sheet.
Sort by Last Name when in a Separate Column to First Name
In situations where first and last name are in separate columns already, follow these steps to sort by last name. If first and last name are in separate columns see the second half of this guide.
1. Highlight your Data Set
Highlight your data set containing the first and last names you want to sort by. We will be using the basic sort range option so we don’t want to highlight header rows.
It’s important to highlight starting with the first value in the last name column so that we can sort by that column in the next step.
2. In the File Menu Click Data > Sort Range > Sort Range by Column (A to Z)
You will see that sort range gives us the option to sort by column B, this is why it was necessary to select the first value in the last names column in the previous step.
3. Your Data Set Has Now Been Sorted by Last Name
Your data set is now sorted by the last name values in column B from Z to A. You can also sort from Z to A if preferred.
Sort by Last Name when in the Same Column as First Name
1. Highlight the entire data set then from the File Menu click “Data” followed by “Split text to columns”
Click and drag the selection to cover the data set you require to sort by last name. In the File menu click Data. From the dropdown select Split text to columns
2. From the pop-up menu ‘Separator’ select “Space”
A small pop-up window will appear, from the dropdown available select Space. If your names are separated by a comma, select comma. etc.
3. The Last Name values have now moved to a new column
With the space selection made, the second name values have now been moved from cells A2 to A10 to B2 to B10
4. Re-highlight the data set, from the File Menu, select “Data” then “Sort range” followed by “Sort range by A to Z”
In order to sort the required date by last name it is important to note that when highlighting the data set you must start with the first cell of the second name values.
In this case, we will click to select then drag and highlight the data set from cell B2 to A10
With the dataset highlighted, go to the file menu and select Data. From the dropdown select Sort range and from the additional menu click Sort range by Column B (A to Z)
5. The dataset is now arranged alphabetically by last name
The dataset is now sorted by alphabetical order of the last name values in column B