How to filter columns in Google Sheets and Excel

A filter is a tool in Google Sheets and Excel used to sort, filter, and hide data. The filter allows one to hide the data from your Sheets without having to delete them. This article will discuss all the workarounds related to filters in Google Sheets and Excel.

To filter columns in Google Sheets

Here are the steps to follow:

1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account).

2. From the Google Apps, click on the Sheets icon and select the existing Sheet.

3. Highlight the column you want to use the filter tool. Click the Data tab on the menu.

4. From the menu, choose the Create a filter button. Immediately, a filter will be created on the selected view.

5. Click on the filter icon on the selected column(s). Choose the sorting format you want.

6. To filter the column by color, click the filter by color button and select the color you want.

7. To filter by condition, click the Filter by Condition button and type the formula on the space.

8. Click the Filter by Values button to filter by values.

9. If you want to hide the view, uncheck the cell data.

To save a view in Google Sheets

Steps to follow:

1. Click the Data tab on the menu.

2. From the menu, hover the mouse over the Filter views button and select the Save as the filter view button.

3. From the section above the columns, click on the Name section and add the name of your filter.

4. Choose the range you want to apply the filter.

To delete a filter in Google Sheets

Steps to follow:

1. Click the Data tab on the menu.

2. Click on the Remove Filter button.

Alternatively

3. From the menu, hover the mouse over the Filter views button and select the Delete all filter views button.

To filter columns in Excel

Here are the steps to follow:

1. Open the Excel application.

2. Highlight the column you want to apply the filter.

3. Click the Data tab on the menu. From the menu, choose the Filter button.


4. Click on the filter icon on the selected column(s). Choose the sorting format you want.

5. To filter the column by color, click the filter by color button and select the color you want.

6. If you want to hide the view, uncheck the cell data.

To change the filter range in Excel

Steps:

1. Click the Data tab on the menu. From the menu, choose the Advanced filter button

2. In the List range section, add the new range.

3. Finally, click the OK button.

To delete Filter in Excel

Steps:

1. Click the Data tab on the menu. From the menu, choose the Clear button.

Also, note how you can sort in Excel

1. Highlight the dataset and click on the Home tab on the menu.

2. From the menu, click on the Sort & Filter drop-down button and choose the Custom sort option.

3. From the dialogue box, locate the Sort by section and choose the column you want to use from the drop-down menu.

4. Customize the sorting and click the OK button.

Leave a Comment