December 4, 2020

How to add Filter in Google sheet

In this lesson we will learn about adding filter in Google sheet. We have the below table containing the start date and duration for each phase along with the daily expense for building an office. 

  • Now to add Filter in this table first select any cell of the table.
  • Then click the Filter icon in the toolbar of the Google Sheet.

How to Filter by Color in Google sheet

Now we will learn How to Filter by Color in Google sheet. To do that first apply conditional formatting on the table by selecting the entire table or only the column on which you need to apply the conditional formatting rule. Then under the ‘Format’ menu click ‘Conditional Formatting’.

Here we have added the conditional formatting rule to fill the cells with yellow colour containing the date is after 15/09/2020.

As you can see below the respective cells have been highlighted with yellow.

  • Now to filter by colour click the filter symbol beside ‘Start Date’ in the second column header.
  • Navigate to ‘Filter by colour’ then you will find the options to filter by Fill colour or Text colour. You can select any one as per your requirement. As in this case there are no different text colours so we have selected to filter by ‘Fill Colour’. In the current column there are two different fill colours available, white and yellow. We have selected here yellow colour.

  • The corresponding rows with the yellow fill colour for the Start Date column have been filtered as follows.

  • Now to remove the filter for the second column only click the filter symbol beside ‘Start Date’ in the second column header.
  • And then navigate to ‘Filter by colour’ and select ‘None’. It will remove the Filter you have applied on this specific column.

  • Or else if you want to remove the filter for all columns then just select any cell of the table and click again the Filter icon in the toolbar of the Google Sheet. As you can see below the filter symbols from the column headers have been removed from the entire table.

Leave a Reply

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