How to Sort in Google Sheets


Google Spreadsheets is a great tool for tracking, analyzing, and organizing your business or business data.

While the app is easy to use, it can be a little tricky if you’re new to organizing data into a digital spreadsheet. But don’t worry! Read on for an easy introduction to sorting in Google Spreadsheets.

First of all, you know that there are many ways to sort data in Google Spreadsheets. Some of the most common features that marketers like you will use when working on Google Sheets are:

  • PivotTables: Useful for collecting data from a large database
  • Analysis of what would happen: allows you to experiment with different scenarios of values ​​and formulas to understand the possible results.
  • Graphs: An easy way to view data in the form of a graph, diagram, or table

While these features can also be found in Microsoft Excel, Google Sheets may be the best option for you. Unlike Excel, Google Sheets does not require a paid subscription.

The tool is free for anyone with a Google account or a Google Workspace account. Many users also find that Sheets is a better tool for collaborative projects compared to Excel.

So how do we get started with Google Sheets? Let’s dive in.

→ Sign in now: Google Spreadsheets Templates [Free Kit]

Sorting by sheet vs. Sorting by Google Spreadsheets by Rank

The latter is especially useful if your spreadsheet contains multiple tables and you want to organize one table without interrupting the others.

For example, the following spreadsheet is sorted by sheet. Book titles (column A) are sorted alphabetically.

In the second example, the titles are arranged in reverse alphabetical order. In both cases, the author, the date of publication and the genre of each book are retained with the corresponding title.

Titles sorted alphabetically in Google SpreadsheetsData sorted in reverse alphabetical order in Google SpreadsheetsThe following example has two separate graphs on a single sheet. Note that the chart contains book titles, authors, release dates, and more. is arranged in alphabetical order, while the record of the book below is not.

This is because the book title chart has been sorted by rank so that it does not interrupt the book record below.

Two graphs are shown on a Google sheet, one is sorted alphabetically and the other is not

How to sort columns and rows in Google Spreadsheets

Knowing how to sort rows and columns in Google Spreadsheets is key to organizing your data. Here’s a step-by-step guide:

Alphabetical or numerical order

Step 1: Open a spreadsheet in Google Spreadsheets and highlight the group of cells that you want to sort. In this example, we will use the chart of the book titles.

Range of selected cells to sort in Google SpreadsheetsIf your sheet has a header row (like the green header row in the example), you’ll want to freeze that row so that it stays in place while you sort.

To do this, select the header row, click the “Show” tab, click “Freeze”, and then click “1 row.” If you do not have a header row, you can proceed to the next step.

Blocked header row in Google SpreadsheetsStep 2: Click the “Data” tab, then “Sort Range” and then “Advanced Range Sorting Options.”

The Data and Sort Range tabs open to show advanced range sorting options in Google SpreadsheetsStep 3: If the columns have titles, click “Data has a header row.”

The data has the header row option selected in Google SpreadsheetsStep 4: First select the column you want to sort and then choose the sort order. AZ and ZA will put your data in alphabetical and reverse alphabetical order, respectively.

If you are working with numbers, AZ will arrange the data in ascending order and ZA will arrange it in descending order.

The selected AZ option to sort the data in ascending order in Google Spreadsheets

Step 5: To add another sort rule, click “Add another sort column”. Then click on the green “Sort” button.

Add another sort column and the Sort button shown in Google SheetsStep 6: To sort an entire sheet, right-click the letter in the column that you want to sort, and then click Sort AZ or ZA.

Sort the A sheet on the circled Z tab

How to filter your data

Filtering your data is especially useful if you want to delve into specific information from a large dataset. It’s also great if you only want certain information to be displayed when people first open your spreadsheet.

Step 1: Select the range of cells you want to filter.

Range of selected cells to sort in Google SpreadsheetsStep 2: Click the “Data” tab and then “Create a filter”.

Create a selected filter tab in Google SheetsAfter clicking “Create a filter”, the graph should look like the following example. Look at the filter icons next to the header name of each column and the new border around the graph.

Filters created for columns within the Google Sheet chartStep 3: Suppose we only want to see book titles that are historical fiction. To do this, click on the filter icon next to “Genre” and then click “Filter by values”.

The filter icon opens in the gender column, and the Filter by Values ​​tab is selected in Google SpreadsheetsStep 4: Then uncheck “Historical Fiction” and click “OK.”

The value of Historical Fiction data is selected while the other values ​​are deselected in Google SpreadsheetsThis can also be done by clicking “Delete” and typing “Historical Fiction”. This last method is great if the value you want to sort doesn’t appear in the list and you want to add yours.

The value of Historical Fiction data is selected while the other values ​​are deselected in Google SpreadsheetsRegardless of the method you choose, the end result should look like this:

Google Spreadsheet Chart has been filtered to show only historical fiction titles

How to sort your data by color

Suppose the titles of the books are color-coded by genre, the historical fiction is orange, the science fiction is blue, and most of the age is purple.

To sort these color-coded titles so that the books for adults are at the top, do the following:

Color-coded data for sorting in Google SpreadsheetsStep 1: Select the cell range.

Range of selected cells to sort in Google SpreadsheetsStep 2: Click the “Data” tab and then “Create a filter”.

The Data tab and the Create selected filter tab have openedFilter created in Google SheetsStep 3: Click the filter symbol in the gender column, then sort by color, fill color, and then purple.

The filter in the gender column has been selected, the Sort by color tab has been opened, followed by the Fill color tab, followed by the value purpleAfter doing so, all adult titles will appear at the top of the chart.

Data encoded in purple is sorted at the top of Google SpreadsheetsIf you want to disable the filter, click “Data” and then “Remove filter.”

Selected Data tab followed by Remove filter to remove Google Spreadsheets filters

Remember that your filter will be visible to anyone with access to the spreadsheet. If someone has permission to edit your spreadsheet, that person can also change the filter.

And this is how you can sort and filter your data in Google Spreadsheets. You can now organize your data digitally in one application.

Remember that Google Spreadsheets is available for free to anyone with a Google Account or a Google Workspace account. It’s also great for collaborative projects with Google’s editing and sharing features. Happy classification!

Google Business Sheet Templates



Source link

Leave a Reply