Cara Menerapkan Filter di Google Sheets

In this document, you will learn how to effectively apply filters in Google Sheets to sort and analyze your data.
Filters allow you to display only the information you need while hiding unnecessary details.

Filtering helps you view only the data you need without deleting or moving anything.

1. Enable Filtering

• Select the data range: Click any cell within the table or range you want to filter.

• Turn on filter: Go to Data > Create a filter, or click the filter icon (funnel symbol) in the toolbar.

• Filter icons appear: A small filter arrow will now be visible next to each column header.

2. Apply Filters

• Click a filter icon: Click the arrow next to the column heading you want to filter.

• Choose your filter method:

  • By values: Check or uncheck specific values to show/hide them.

  • By condition: Set rules like "greater than," "contains," or "starts with."

  • By color: Filter rows based on text or fill colors.

3. Save Filter Views (Optional)

Use this if multiple users need different filtered views:

• Go to Data > Filter views > Create new filter view.

• Name the view for easy reference.

• Apply your filters, just like in step 2.

• Save and access later under Data > Filter views.

4. Remove Filters

• To reset the view, go to Data > Remove filter, or click the filter icon again and choose Remove filter.

Step-by-Step Guide: How to apply filter in Sheets

Step 1

To begin applying a filter in your sheet, navigate to the menu and click on the filter icon. After selecting the appropriate element, a filter button will be visible, which you can use to initiate the filtering process.

Step 2

Once the filter menu is open, you can choose to filter by condition. There are various options available such as filtering by text, date, and more.

Step 3

To filter data where text begins with a specific letter, for example, enter "S" to display only the values starting with "S".If you need to modify the filter, you can remove it and then apply a new filter, such as filtering for entries that begin or end with the letter "S".

Step 4

Similarly, to view entries where names end with the letter "M", apply the "ends with M" filter. This will display only the entries that match this criteria.

Step 5

The filter function can also be accessed through another method. You can go to the data menu for additional options.

Method 2

Step 1

Within the data menu, there is an option to insert and create a filter. This serves as an alternative method to initiate the filtering process.

Step 2

After creating a filter, you can proceed with the same process of filtering by condition to refine your data display.So thats how to apply filters in sheets.