Sheets is Google’s answer to Excel’s dominance in the spreadsheet game. As such, it packs many of the convenient features to help you through your day. One vital feature is the ability to navigate your data and make sense of it all. Here’s how to sort in Google Sheets to save you time.
One of the most common uses for a spreadsheet is tracking your contact list, so that’s how we’ll structure this example. Sorting your contacts is one of the easiest ways to alphabetize in Google Sheets, so leave your spreadsheet headaches behind. The process is the same if you’re looking to sort by date in Google Sheets too.
How to sort in Google Sheets:
1. Before you can dig into sorting, you’ll have to decide what data is important. Start by selecting all of the rows and columns you plan to use.
2. Head up to the Data tab, located between Format and Tools. This is where you’ll manage your sorting, whether you choose to sort your Google Sheets by column or otherwise.
3. Scroll down to the option that says Sort Range. This should open a menu box. If your data has a header line, select the checkbox. In our case, we’ve chosen not to highlight the header line.
4. The line that says Sort By is your opportunity to decide how you want to organize your data. Because we’re using a contact list, we’re going to sort the example by last name (Column B). Open the dropdown list to select the column and then choose between the A → Z or Z → A buttons and then click Sort.
You should now see all of your contacts organized alphabetically by last name. A quick Google Sheets Sort can help you save plenty of time in finding a specific contact! Learning how to filter in Google Sheets is a bit more complex, so check back soon for a guide to help you out.