How To Filter Rows In Google Sheets
This tutorial will demonstrate how to filter rows in Excel and Google Sheets.
Excel enables usa to store information in a table format made upwardly of rows and columns. These tables are often in database format with the columns equally the headers (database fields), and the rows every bit the database entries. Excel then has some fabulous database features, ane of which is the ability to filter lists of data. Filtering data lists enables you to locate and report on a subset of the information.
Formatting Data as a Tabular array
Once you have a list of data stored in Excel, you lot tin can cull to format the information every bit a table. Doing this volition automatically add filters to the columns in the table.
Click in the data, and then in the Ribbon, select Habitation >Styles > Format as Table.
Select the type of format yous wish to apply, and and so, in the Format As Tabular array dialog box, make certain the 'My tabular array has headers' is checked.
The format will exist applied to the data, and a new tab chosen Tabular array Design will appear in your Ribbon.
Adding a Filter to Excel Information
If yous practice not format your data as a table, you tin still add filters to the data manually.
Click in your data, and and so, in the Ribbon, select Dwelling house > Editing > Filter.
Small drib down arrows will be applied to the header row of your data.
Filtering by Data in the Drib Down Listing
Click on the drop downwards arrow to the correct of the heading you wish to filter on, and then remove the check mark from Select all.
In the listing of entries that is shown, click in the checkbox of the ones that you lot require to be shown in your filtered data.
Click OK to prove the data.
You lot will find that the data that does not match what you take selected is subconscious – the row headers turn blue equally but the rows for the filtered information is shown. Yous volition also find that the header that y'all have filtered on has a small icon of a filter indicating that that column of data has the filter applied to it.
Click on the small filter to actuate the drop down list. Select "Clear Filter" to remove the filter from the data.
OR
select (Select All) and then click OK to remove the filter from the data.
OR
In the Ribbon, select Home > Editing > Filter > Clear.
This will clear the filter from the data, but the filter headers volition still remain at the tiptop of each column of information.
Filtering by Text
Click on the drop-down arrow next to the header cavalcade of the data you wish to filter, then select Text Filters.
Select Contains… from the list shown and then type a discussion that is contained within the data e.yard., "Science"
Click OK to filter the data.
Sorting a Filter
The filter drop downwardly list has the power to sort the filtered data.
In the filter drop downwardly listing, select Sort A to Z or Sort Z to A, depending on how you wish to sort the filtered data.
The data that is filtered volition be sorted – you will find a small pointer appearing next to the filter, indicating that the filtered information is sorted.
If we remove the filter, yous will discover that the rest of the data in the list has not been sorted.
To sort the entire list of data, once the filter is cleared, you tin select Sort A to Z or Sort Z to A idue north the filter drop down listing
OR
In the Ribbon, select Home > Editing > Sort & Filter and then select Sort A to Z or Sort Z to A.
Removing Filters
To remove the filters from the data list, in the Ribbon, select Abode > Editing > Sort & Filter and then click on Filter once again. This is a toggle button so will either utilize filters to the list, or remove filters from the list.
Filtering by Color
If you take formatted your information past color, Excel has the ability to filter the data based on the colors applied.
In the filter drib down, select filter by Color.
Select "More Cell Colors" to see all the prison cell colors applied to the data.
Select the colour y'all wish to filter on, and so click OK.
How to Filter Rows in Google Sheets
Filtering data in Google sheets is much the same as filtering information in Excel.
In the Menu, select Data > Create a Filter.
In the drop down list, (one) click Articulate to clear all the cheque marks from the data, and and so (2) select the data items from the list.
Click OK to filter the data.
To remove the filter, in the drop downwardly listing, click (one) Select All and and so click (2) OK.
The filter will be cleared but the filter drib downwards will still exist showing on the cavalcade headers.
To filter the information past specific text, select Filter by condition and and so in the drop down below, select Text contains. In that location are multiple conditions that you are able to filter on.
(i)Type in the text that you lot wish to filter on, and and then (2) click OK.
Only the rows that contain the required data will be shown.
Once we have filtered our data, we tin likewise sort the information equally we can in Excel.
In the filter driblet down list, select Sort A to Z or Sort Z to A, depending on how you wish to sort the filtered data.
Annotation that as with Excel, this will merely sort the filtered information – not the entire data list.
To remove the filter, select Filter by condition > None in filter the drop down list, and then click OK.
We tin can also filter by colour in Google Sheets.
In the drib down filter list, select Filter by colour > Make full colour and so select i of the fill colors shown.
The information will be filtered by the color selected.
To remove the filter, select Filter by color > None in the drop down filter listing.
How To Filter Rows In Google Sheets,
Source: https://www.automateexcel.com/how-to/filter-rows/
Posted by: loafters.blogspot.com
0 Response to "How To Filter Rows In Google Sheets"
Post a Comment