How to Filter Spreadsheet Data in Google Sheets | How to Create Filters in Google Sheets

In this video, we will show you how to filter data in Google Sheets.

The filter option allows you to temporarily hide some of the data in a table, without effecting the original data, so you can focus on the data you want to see. Let’s say we want to filter all the sales in the enterprise segment above fifty thousand, being shown in ascending order. With the filter functionality, we can create this view without changing the order of the original data.

Let’s select the entire table here, and click on the Create a filter option. With that done, you can see the filter icon next to every heading in the table here.

Clicking on the icon will open up the filter menu. Over here, you can either filter the data according to the color, a condition or by the values appearing in the column.

We want to filter the segment to only see the enterprise sales. So let’s open this option and clear the selection first. After that, let’s choose the “Enterprise” option here and click on OK.

You can see that the entire sheet is filtered and only shows the data for enterprise sales.

Next, we only want to see sales data above fifty thousand dollars. So let’s open the filter menu in the amount column here.

Let’s expand the filter by condition option here and open up the drop down menu.

Here, you can see a lot of conditions to filter your data by. Lets find and select the greater than option.

After that, let’s enter fifty thousand and click on OK.

You can see that the sheet is filtered out to only show sales in the enterprise segment which is above fifty thousand dollars.

You can open up the filter menu here and save the filter view option. This way, the original data sorting will not be changed.

We can give the filter view a name and now we can make changes to how the data is sorted.

So, for example let’s head back to the amount filter menu and click on the ascending option here. Once done, simply click on the close button here to go back to the original view of the data.

You can turn off the filters and see that the original data remains unchanged. To go back to the filter view, simply open up the filter menu and the filter view saved earlier would be displayed here.

Clicking on it will open up the filter view showing only enterprise sales above fifty thousand dollars.

That’s all!

❓💬 Would you like to know about any particular Google Sheets feature? Let us know in the comments below.

#HowTech #GoogleSheets
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here https://t.me/howtechtv
✅ Commercial questions [email protected]
✅ Facebook   / howtechtv  
✅ Instagram   / howtechprojects  
✅ Twitter   / howtechprojects