• About
  • Advertise
  • Privacy & Policy
  • Contact
Tech News, Magazine & Review WordPress Theme 2017
  • Technology
    • Smartphones
    • Software & Application
    • Scientific
    • Artificial Intelligence
    • Apple
    • Microsoft
    • Google
  • Review
    • Mobile Review
    • Laptop Review
    • Tablet Review
    • Tv Review
    • Wearable Review
    • Speaker & Headset Review
  • How To
    • Smartphone learning
    • Computer Learning
    • Photography Learning
  • Buying Guide
    Galaxy S21 Fe vs S21

    Galaxy S21 Fe vs S21; Which one should we buy?

    Galaxy Watch Buying Guide

    Galaxy Watch Buying Guide; Everything you need to know about the Samsung smartwatch

    The Best 4K TVs under $500

    The Best 4K TVs under $500

    iPhone 13 Buying Guide

    iPhone 13 Buying Guide; Everything you need to know about new Apple phones

    Samsung phone buying guide

    Samsung phone buying guide

    Gaming Monitor Buying Guide

    Gaming Monitor Buying Guide

    Tablet buying guide

    Tablet buying guide and tips you need to know before buying

    SSD Buying Guide for PlayStation 5

    SSD Buying Guide for PlayStation 5

    TV buying guide

    TV buying guide; Everything you need to know before choosing a TV

  • Wironal Plus
    • Car
    • Personal development
    • Health and Medical
    • Game
    • Business
    • Travel and tourism
No Result
View All Result
  • Technology
    • Smartphones
    • Software & Application
    • Scientific
    • Artificial Intelligence
    • Apple
    • Microsoft
    • Google
  • Review
    • Mobile Review
    • Laptop Review
    • Tablet Review
    • Tv Review
    • Wearable Review
    • Speaker & Headset Review
  • How To
    • Smartphone learning
    • Computer Learning
    • Photography Learning
  • Buying Guide
    Galaxy S21 Fe vs S21

    Galaxy S21 Fe vs S21; Which one should we buy?

    Galaxy Watch Buying Guide

    Galaxy Watch Buying Guide; Everything you need to know about the Samsung smartwatch

    The Best 4K TVs under $500

    The Best 4K TVs under $500

    iPhone 13 Buying Guide

    iPhone 13 Buying Guide; Everything you need to know about new Apple phones

    Samsung phone buying guide

    Samsung phone buying guide

    Gaming Monitor Buying Guide

    Gaming Monitor Buying Guide

    Tablet buying guide

    Tablet buying guide and tips you need to know before buying

    SSD Buying Guide for PlayStation 5

    SSD Buying Guide for PlayStation 5

    TV buying guide

    TV buying guide; Everything you need to know before choosing a TV

  • Wironal Plus
    • Car
    • Personal development
    • Health and Medical
    • Game
    • Business
    • Travel and tourism
No Result
View All Result
Wironal Tech
No Result
View All Result

How to filter in google sheets

Wironal by Wironal
October 26, 2022
Reading Time: 6 mins read
Home How To Computer Learning
Share on FacebookShare on Twitter
5
(1)

How to filter in google sheets? In Google Sheet, you can filter the data of a sheet by color, condition, and values ​​to more easily access the data you want.

When you have to find specific data in a spreadsheet full of data, filters in Google Sheet can help. All you have to do is enter a number of criteria for the data you need to see the results with a few clicks. In this article, we want to review the basics of applying a few simple filters in Google Sheet.

Activate the filter in Google Sheet

You can use the filter feature in Google Sheet immediately after activating it. When the filter is activated, a filter icon is displayed above the columns containing the data, with the help of which you can filter any column you need.

Depending on how you configure it, you may need to select a cell in your datasheet area. For example, if you have blocks of data separated by empty columns, select the cell in the block to which you want to filter.

how to filter in google sheets

If you want to be able to filter each column in the sheet, you have to select the whole sheet by clicking on the rectangle at the top left (where A and 1 meet).

RelatedPosts

How To Lock Apps On iPhone?

How To Lock Apps On iPhone?

November 11, 2022
How to hold the camera properly?

Introduction to Photography; How to hold the camera properly?

June 12, 2022
How to install a font in windows 11?

How to install a font in windows 11?

October 26, 2022
How to use 2 WhatsApp in one iPhone?

How to use 2 WhatsApp in one iPhone?

October 26, 2022

Go to the right side of the toolbar and click Create a Filter .

You are now ready to apply a filter. You can apply the filter based on color, conditions or values.

  • How to search in Google Sheet

Filter by color

If you use color in your spreadsheet to highlight text or cells, you can apply the filter based on the colors you use.

Click the filter icon next to the title of the column you want to filter. Hover over the Filter by Color, select Fill Color or Text Color, and then select a color from the drop-down menu.

how to filter in google sheets

Your sheet will be updated with the filtered data and the remaining data will be hidden in the column.

Filter by condition

You may want to filter out empty cells or those that contain text, dates, numbers, or special formulas. Filtering by condition, all of these options along with the specifications of each gives you a valley.

For example, you can filter text that starts or ends with a specific letter, dates that are before or after another date, or numbers that are greater than or less than a certain value.

Click on the filter icon in the column header and open Filtering by condition .

In the drop-down box, select the condition.

how to filter in google sheets

In this example, we filter the numbers that are Greater Than (Equal to) or Equal To (equal to) 250.

Therefore, after selecting the condition, you must enter a value or formula in the box just below it. Click OK to apply the filter .

Only values ​​greater than or equal to 250 are now displayed in our selected column.

how to filter in google sheets

Filter by values

One of the ultimate ways to filter data in Google Sheet is by Filter by Values. When you use this filter, the sheet only shows you the values ​​in that column, so you can select the values ​​you want to see in the list or use the search box to quickly find the value you want.

  • How to divide excel cells by a number

Click the filter icon in the column title and expand the Filter by Values list. Depending on the amount of data you have in the column, you may want to use the Select All or Clear options. Then select or deselect only the items you want.

You can also scroll down the list of data and mark or uncheck the values ​​in it, or find an existing value in the search box. Click OK to apply the filter. In this example, we wanted to filter the April and August values.

how to filter in google sheets

Your sheet is updated to show only the data in the filter and hide the rest.

Disable the filter in Google Sheet

Unlike Microsoft Excel filters, Google Sheets does not currently offer a one-click way to clear filters. So, once you have finished using the filter, you can simply disable it the same way you activated it.

Go to the right side of the toolbar and click Turn Off Filter .

how to filter in google sheets

We hope you find this tutorial useful. As always, you can share your questions with us and Wironal users from the comments section.

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 1

No votes so far! Be the first to rate this post.

Tags: google sheet
Previous Post

how to draw graphs in excel sheet

Next Post

How to calculate the total working hours in excel

Wironal

Wironal

Related Posts

How To Lock Apps On iPhone?
Apple

How To Lock Apps On iPhone?

November 11, 2022
How to hold the camera properly?
Photography Learning

Introduction to Photography; How to hold the camera properly?

June 12, 2022
How to install a font in windows 11?
Computer Learning

How to install a font in windows 11?

October 26, 2022
How to use 2 WhatsApp in one iPhone?
Apple

How to use 2 WhatsApp in one iPhone?

October 26, 2022
Next Post
how to calculate the total working hours in excel

How to calculate the total working hours in excel

Leave a Reply Cancel reply

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

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.

Recommended.

default Firefox search engine

Bing is likely to replace Google as the default Firefox search engine

December 10, 2021
Microsoft Start

Microsoft Start was unveiled as a new Microsoft news feed

December 4, 2021
iPad Mini 6 Vs iPad Mini 5

iPad Mini 6 Vs iPad Mini 5

October 24, 2022

Subscribe.

Trending.

How to benchmark my graphics card

How to benchmark my graphics card?

October 26, 2022
How to install google chrome extension on android

How to install google chrome extension on android

October 26, 2022
iPhone 13 Pro max Vs OPPO Find X3 Pro

iPhone 13 Pro max Vs OPPO Find X3 Pro

October 24, 2022
Pupil size indicates the intelligence of individuals

Pupil size indicates the intelligence of individuals

October 24, 2022
How to reduce data usage in telegram

How to reduce data usage in telegram?

October 26, 2022
Wironal

Wironal is not just a technology news portal. Although at first glance we may be a young website for information on technology news and technology events...

Follow Us

Reviews

Samsung Galaxy A53 5G Review

Samsung Galaxy A53 5G

By paying much less and buying the Galaxy A52s, you will $449
Xiaomi Poco X4 Pro 5G Review

Xiaomi Poco X4 Pro 5G

The Poco X4 Pro 5G is much more upgraded than its $275

Recent News

How To Lock Apps On iPhone?

How To Lock Apps On iPhone?

November 11, 2022
What temperature can damage a computer

What temperature can damage a computer?

November 11, 2022
  • About
  • Advertise
  • Privacy & Policy
  • Contact

© 2022 Wironal - Technology news, review, buying guide and learning Wironal.

No Result
View All Result
  • Technology
    • Smartphones
    • Software & Application
    • Scientific
    • Artificial Intelligence
    • Apple
    • Microsoft
    • Google
  • Review
    • Mobile Review
    • Laptop Review
    • Tablet Review
    • Tv Review
    • Wearable Review
    • Speaker & Headset Review
  • How To
    • Smartphone learning
    • Computer Learning
    • Photography Learning
  • Buying Guide
  • Wironal Plus
    • Car
    • Personal development
    • Health and Medical
    • Game
    • Business
    • Travel and tourism

© 2022 Wironal - Technology news, review, buying guide and learning Wironal.

Welcome Back!

Login to your account below

Forgotten Password?

Retrieve your password

Please enter your username or email address to reset your password.

Log In