Hướng Dẫn Cách Tạo Bộ Lọc Trong Google Sheet S, Hướng Dẫn Cách Tạo Bộ Lọc Trong Google Sheets

post-promotion-placement#checkSidebarAdDisplayCondition” data-controller=”sticky-ad post-promotion-placement”>
Read Time:8 minsLanguages:url-selector#selectionChanged” data-controller=”url-selector”>EnglishEspañolBahasa IndonesiaPусскийукраїнська моваTiếng Việt

Data is taking over the world. And often, we just have so much of it that it”s a challenge to find meaning in it to understand the situation at hand.

Đang xem: Cách tạo bộ lọc trong google sheet

Spreadsheets are one of the best ways to analyze data sets for their structure and ease of use. But many data sets are just too big to easily get your hands around. You need ways of finding the data you”re looking for and narrowing down the dataset.

In this tutorial, you”ll learn to apply a Google Sheets filter to limit the data you”re seeing. Then, you”ll learn the secrets of using the Google Sheets sort function to put data in the sequence you need to see it in.

*
*
*

In the example data included with this tutorial, each row is a “record” of an employee we”re recruiting, and each column has an attribute that describes that candidate.

When you sort that data, it”s crucial that it stays grouped together properly. If you only sort the column that contains the amount of the sale, suddenly you”ve got mismatches in your data! A $100 sale is now assigned to the wrong customer, for example. 

This is why sorting data properly is so crucial. Let”s walk through a few examples below. 

How to Sort Data in Google Sheets

One of the most common Google Sheets sorting tasks is to sort your data from A-Z. It usually makes reading the data easier, and it also simplifies finding specific rows that you know you”re looking for.

Before I start to do any sorting, my first step is to always highlight the entire table. This minimizes the chances that we”ll accidentally sort by the wrong column, or only sort part of the data.

Once you”ve got the entire set of data highlighted, go to the Data > Sort Range menu option, as you can see in the screenshot below.

*
*
*

Click add another sort column to give yourself multiple sort rules for your data.

Use these multi-level sorts to really specify how the finished data should appear. You can add as many sort rules as you want to get the data order just right.

3. Use Google Sheets Filters

While sorting changes the order and sequence of the data in a spreadsheet, filtering changes what data is currently visible in the spreadsheet. Let”s learn how to apply Google Sheets filters so that we can narrow down the data that”s in view.

Xem thêm:

To start adding filters, highlight your data table. Then, go to Data > Create a Filter on the Sheets menu.

Now that you”ve turned on filtering, you”ll see a small icon on the upper right corner of the header. Click on that icon, and then you”ll see a list of values that are in that column in the pop-up menu as you can see in the screenshot below.

*
*
*

Click on the icon in the column header to choose what you want to limit your data to.

On this pop-up, simply toggle off or on the criteria that you want your data to meet. When you press OK, the spreadsheet will be narrowed down to only show data that matches those Google Sheets filter rules.

Much like sorting, you can stack multiple levels of filtering. In the example below, I added a filter to the Salary Grade column.

*
*
*

This is a picture-perfect example of how useful filtering can be to make sense of a data set. By combining an “interest” filter with a “salary grade” filter, I”ve got a refined list of two candidates out of a possible 100.

It”s an important distinction to remember that filtering data doesn”t delete or remove data. It”s still behind the scenes, waiting to show again as you change the filtering settings.

Watch Out for “Missing” Data

Here”s something to think about while you”re working with filtered data: you need to be careful about what data you leave behind the scenes. I can”t tell you how many times I”ve been working in a spreadsheet and missed out on the fact that data was “missing” because it was removed from the Google Sheets filter view.

I always keep my eye out for two things if the data isn”t making sense:

The filter icon at the top of the columnThe row numbers in Sheets on the left side

*
*
*

Notice in this screenshot that the row numbers (outside of the spreadsheet at the far left) are no longer in sequence, as well as the filtering icon above column F.

Xem thêm: Cách Sửa Phông Chữ Bị Lỗi Trong Word Tự Động Cực Kỳ Nhanh Chóng, Đơn Giản

These two tricks are perfect for ensuring that you never “miss” data in the spreadsheet.

Recap & Keep Learning

Filtering and sorting are crucial tools for narrowing and selecting data. Check out the tutorials below for more tips on using Sheets for data review and analysis. 

You”ve just learned how to use filter and sort in Google Sheets. How do you handle working through huge data sets? Do you use the Google Sheets sort and Google Sheets filter tools to narrow down your data sets, or do you use other analytical tools?

Leave a comment

Your email address will not be published. Required fields are marked *