Read Time:8 minsLanguages:url-selector#selectionChanged" data-controller="url-selector">EnglishEspañolBahasa IndonesiaPусскийукраїнська моваTiếng ViệtData 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" /> Read Time:8 minsLanguages:url-selector#selectionChanged" data-controller="url-selector">EnglishEspañolBahasa IndonesiaPусскийукраїнська моваTiếng ViệtData 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" />

Cách Tạo Bộ Lọc Trong Google Sheet

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 lớn underst& the situation at hand.

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

Spreadsheets are one of the best ways khổng lồ analyze data sets for their structure và ease of use. But many data sets are just too big khổng lồ easily get your hands around. You need ways of finding the data you"re looking for & narrowing down the datamix.

In this tutorial, you"ll learn khổng lồ apply a Google Sheets filter khổng lồ limit the data you"re seeing. Then, you"ll learn the secrets of using the Google Sheets sort function to lớn put data in the sequence you need khổng lồ 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 khổng lồ 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 khổng lồ sort your data from A-Z. It usually makes reading the data easier, và it also simplifies finding specific rows that you know you"re looking for.

Before I start lớn do any sorting, my first step is to lớn 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 sầu got the entire set of data highlighted, go khổng lồ the Data > Sort Range thực đơn option, as you can see in the screenshot below.

*
*
*
Click add another sort column khổng lồ give yourself multiple sort rules for your data.

Use these multi-màn chơi sorts to lớn really specify how the finished data should appear. You can add as many sort rules as you want khổng lồ 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: Cách Chỉnh Sửa Văn Bản Trong Word 2010, Thêm Và Chỉnh Sửa Văn Bản

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 ibé, & then you"ll see a các mục of values that are in that column in the pop-up thực đơn as you can see in the screenshot below.

*
*
*
Cliông xã on the ibé in the column header to lớn choose what you want to lớn limit your data to lớn.

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 staông chồng 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 phối. By combining an "interest" filter with a "salary grade" filter, I"ve got a refined menu 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 khổng lồ 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 lớn be careful about what data you leave sầu behind the scenes. I can"t tell you how many times I"ve been working in a spreadsheet và 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 inhỏ 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 ibé above sầu column F.

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 & selecting data. Cheông chồng out the tutorials below for more tips on using Sheets for data review và analysis. 

You"ve sầu just learned how khổng lồ use filter and sort in Google Sheets. How vị you handle working through huge data sets? Do you use the Google Sheets sort & Google Sheets filter tools lớn narrow down your data sets, or vày you use other analytical tools?