قالب وردپرس درنا توس
Home / Tips and Tricks / Filter Google Sheets data without changing what collaborators see

Filter Google Sheets data without changing what collaborators see



  Google Sheets logo

Google Sheets filters let you analyze data in your document by showing only what you want. However, it also changes as others see the document. To use filter views to leave each employee's view unchanged:

Launch Google Sheets and open a spreadsheet to get started.

  Example of a dataset in Google Sheets.

Click Data> Filter Views> Create New Filter View.

 Click Data> Filter Views> Create New Filter View. "Width =" 650 "height =" 368 "src =" /pagespeed_static/1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "/> </p>
<p>  The activated line numbers and column letters turn to dark gray This time, you should give your filter view a name to distinguish it from other views you create in the future, and check that the area is correct – you can do both later Edit at any time on demand. </p>
<p>  <img class=

For this guide we would like to filter everything in the table, the one Price per unit of more than $ 10. Click on the filter icon in the "Unit Price" box.

 Click the filter icon next to the column name you want to filter for.

For this next part, you can choose to filter by either values ​​or conditions to analyze your data. "Filter By Value" provides an easy way to date n and select specific values ​​in the column. Use Filter By Condition to refine the search for data using custom formulas.

First, click "Filter By Condition" to expand the section, click the drop-down box and then click "Larger" as an option.

 Click

. RELATED: Marking a line in Google Sheets with conditional formatting

Enter the terms of the filtering and click the "OK" button.

 Type

Just so you can now view all products that cost more than $ 10 per unit without affecting the view of other contributors. [19659003]   Voila! The data in the table now only displays rows that cost more than $ 10 per unit.

Since you can only switch one filter at a time, you can stack filters for each column to increase the potential for data analysis. Just click another filter icon and try again.

 Add another filter to the same view by clicking an additional filter icon in the column you want to filter.

To disable all filter views, click on the "X" in the upper right corner of the sheet.

 Click

Whenever you want to reactivate a filtered view, click Data> Filter Views, and then select a filter to display.

 Do you want to view your view again? Click Data> Filter Views and select a filter to display. "Width =" 650 "height =" 451 "src =" /pagespeed_static/1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "> </p>
<p>  One of the benefits of filtering views is the ability to display filtered data without changing the other people's table view. You can also use view-only viewers to use your filter views . </p>
<p>  Click Data> Filter Views, and then select one of the custom views created by other employees. </p><div><script async src=

 Filter Views Are Not Displayed If you can not change someone else's perspective, they can toggle everyone out of the menu by selecting a filter.


Although this is a very basic use of a filtered view, there seems to be no restrictions on its use. You can stack multiple filters and one another. You can even add custom formulas to yours Analyze and sort data without disturbing others Pe which you work with.


Source link