How To Filter Data In Google Sheets

When you lot have a spreadsheet full of data and need to find something specific, filters in Google Sheets can help. Just enter some criteria for the data you lot need and encounter your results in a few clicks.

While filters are robust, they don't have to be intimidating, so we're going to become through the basics of applying a few uncomplicated filters in Google Sheets.

Enable the Filter in Google Sheets

Once y'all enable the filter characteristic in Google Sheets, it's on and ready to utilize. This applies a filter icon to the top of columns with data. You can and then filter whichever column you need.

You might need to select a jail cell in the information surface area of your canvas depending on how you lot set it up. For instance, if you take blocks of data separated by bare columns, choose a jail cell in the block where you want the filter.

Or, if you want to be able to filter whatsoever cavalcade in the sheet, select the entire sheet by clicking the rectangle on the pinnacle left where the A and 1 run across.

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

At present, you're set to apply a filter. You can filter by color, condition, or values.

Filter by Color

If you lot utilise colour in your spreadsheet to highlight text or cells, you can filter past the colors that you use.

Click the filter icon in the header for the column that you lot want to filter. Move your cursor to "Filter by Color," pick "Fill Colour" or "Text Color," so choose the color in the pop-out list.

Your sheet will update with the filtered information, hiding the remaining data in the column.

Filter by Condition

Maybe you want to filter out blank cells or those with certain text, dates, numbers, or formulas. Filtering past condition gives you lot all of these options with specifics in each one.

For example, y'all can filter text that starts or ends with something in item, dates that are earlier or later some other date, or numbers that are greater than or less than a certain value.

Click the filter icon in the column header and expand "Filter past Status."

In the drop-down box, choose the condition.

For our example, we'll filter numbers that are "Greater Than" or "Equal To" 250.

So, after you pick the condition, enter the value (or formula) in the box directly below it. Click "OK" to apply the filter.

And at that place we have it. Simply values in our cavalcade that are greater than or equal to 250 volition brandish.

Filter by Values

One final way to filter data in Google Sheets is past specific value. When you employ this filter, Sheets will display only the values in that column for you lot, so y'all tin choose those in the list that you want to meet or use the Search box to observe one quickly.

Click the filter icon in the cavalcade header and expand "Filter by Values." Depending on how much information you have in the column, y'all might want to use the "Select All" or "Articulate" options. So select or deselect but those that y'all want.

Alternatively, yous can go downward to the data list and check or uncheck the values there or discover one with the search box. Click "OK" to apply the filter.

And similar the other filter types, your canvass will update to display only the data in your filter while hiding the rest.

Disable the Filter in Google Sheets

Unlike the filters in Microsoft Excel, Google Sheets doesn't currently provide a way to articulate a filter with a click. Then, when you finish using a filter, you tin only plow it off the same style you turned it on.

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

If using the filters in Google Sheets works well for you, you can also save filter views. Check out our tutorial for how to filter when collaborating in Google Sheets, which walks you through it.

How To Filter Data In Google Sheets,

Source: https://www.howtogeek.com/729347/how-to-filter-in-google-sheets/

Posted by: harrisblapeneve.blogspot.com

Share this post