Google Drive logo on smartphone stock photo 1

Sheets is Google’s answer to Excel’s dominance in the spreadsheet game. As such, it packs many of the convenient features that you’ll need to get 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.

See also: 10 best office apps for Android to get work done!

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.

See also: How to use Google Drive: Everything you need to know

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.

sort in google sheets 1

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.

sort in google sheets 2

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.

sort in google sheets 3

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.

sort in google sheets 4

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.

See also: 10 best Excel apps and spreadsheet apps for Android!

Comments
Read comments