{"id":7551,"date":"2022-01-18T10:53:00","date_gmt":"2022-01-18T09:53:00","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=5994"},"modified":"2025-06-23T20:18:45","modified_gmt":"2025-06-23T18:18:45","slug":"filtrer-les-feuilles-de-calcul-de-google-sans-affecter-les-autres-utilisateurs","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/filter-google-sheets-without-affecting-other-users\/","title":{"rendered":"Comment filtrer Google Sheets sans affecter les autres utilisateurs ?"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ da_disable_devices=”off|off|off” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

One of the reasons why spreadsheets are used as a collaborative tool is their information storage capacity. The downside to working with large amounts of data is it can become time-consuming to find specific information. Luckily, Google Sheets has easy-to-use filters in the app to make this process more efficient. However, since more users will be working with the same information, it is crucial to establish a filtering system that aids, and not hinders, their experience. By the end of this article, you will know how to filter information in Google Sheets. What\u2019s more, you can explore how you can filter your Google Sheets without affecting other users through the Sheetgo web app.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to filter your Google Sheets<\/h2>\n

There are two main ways you can filter data directly in Google Sheets: direct filters and filter view.<\/p>\n

1. How to apply the direct filter to a Google Sheet<\/h3>\n

This is perhaps the most straightforward way to filter data. This feature is useful for any scenario in which you want a group of users to see the same filtered information as you. Imagine that I am the head of an IT department and I have a database in Google Sheets of all past and future projects.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/google-sheets-filter-view.png” alt=”google sheets filter view” title_text=”google sheets filter view” align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

I want to share the monthly assignments with my team. In order to do this, I can apply a direct filter to show the tasks that belong to the upcoming month.<\/p>\n

First, click on the funnel icon located on the far right of the toolbar. You should see a filter sign appear at the top of each column. Click this sign in your desired column \u2013 in my example, column E. A dropdown menu should appear.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/google-sheets-filter-view-1.png” alt=”google sheets filter view 1″ title_text=”google sheets filter view 1″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Now, clear your filters to start fresh. Simply expand the Filter by values<\/b> section and click Clear<\/b>. Now it\u2019s time to customize your filters. Click on the values that you wish to filter your data by. In this example, I want to filter my data according to the tasks due in May.<\/p>\n

Once finished, click OK<\/b>.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/google-sheets-filter-view-2.png” alt=”google sheets filter view 2″ title_text=”google sheets filter view 2″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

As you can see below, your team will now only see the task information relating to the month of May.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/google-sheets-filter-view-3.png” alt=”google sheets filter view 3″ title_text=”google sheets filter view 3″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

As previously mentioned, this filtering method is suitable for those cases in which you want everyone to see the same filtered data. However, what if you want different users to be able to view different data? Or what if you want to share different filters with different people? The Google Sheets filter view feature is the best option to use for these reasons.<\/p>\n

More importantly, you may also need to use these customized filters in the future. This is where Google Sheets filter view option comes in handy.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2. How to apply the filter view to a Google Sheets<\/h3>\n

Imagine that you want the spreadsheet to keep all data visible and unfiltered and leave this for each users\u2019 convenience. The filter view allows users to work on the same spreadsheet without affecting what the others see. What\u2019s more, you can save custom filters to use again in the future. Let\u2019s take a look at how to create a filter view.<\/p>\n

Firstly, remove the filters from your columns. Do this by simply clicking the filter icon at the top of your column, expand the Filter by values<\/b> section and click Select all<\/b>. All of your data should reappear. To add a filter view, click on the arrow next to the funnel icon (not the funnel icon as before) and select Create new filter view<\/b> from the drop-down menu.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/google-sheets-filter-view-4.png” alt=”google sheets filter view 4″ title_text=”google sheets filter view 4″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

You might get a message reminding you that only your view has changed. You can dismiss the message and proceed to rename the filter Filter 1<\/b> to suit your needs.<\/p>\n

Let\u2019s say I now want to view the tasks due in June. In this example, I\u2019ll rename it \u201cJune tasks.\u201d Then, apply the filter conditions of your choice. I have applied filters to show only the June tasks.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/google-sheets-filter-view-5-2.png” alt=”google sheets filter view 5″ title_text=”google sheets filter view 5″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Remember that when you apply filter conditions with filter view, it is only your view that has been modified and won\u2019t affect what the rest of your team sees. If you want to edit, duplicate or delete the filter view you have created, click the settings icon on the right-hand of your spreadsheet and select your desired action.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to reset the filter view on Google Sheets<\/h4>\n

If you want to reset or remove the filter view conditions to your Google Sheet, simply click the close button (X<\/b>) located next to the Settings<\/b> icon on the top right of the spreadsheet.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/google-sheets-filter-view-6-1.png” alt=”google sheets filter view 6″ title_text=”google sheets filter view 6″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

In case you need to apply the same filter in the future, select the customized filter from the drop-down menu, next to the funnel icon. As you can see, the recently customized filter, \u201cJune tasks\u201d now appears on the list.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/google-sheets-filter-view-7-1.png” alt=”google sheets filter view 7″ title_text=”google sheets filter view 7″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

With the Google Sheet filter view, you can have as many filter views as needed, according to task or user requirements. If you give access to a coworker or client, you can directly choose the data that will be viewed and made accessible to them. Even though others may be working on that same Google sheet, you will not affect their view at the time.<\/p>\n

Please note:<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n