درحال‌حاضر صفحه درخواستی به زبان شما دردسترس نیست. می‌توانید زبان دیگری را در انتهای صفحه انتخاب کنید یا بااستفاده از ویژگی ترجمه داخلی Google Chrome هر صفحه وبی را فوراً به زبان انتخابی‌تان ترجمه کنید.

Filter charts and tables with Slicers


Want advanced Google Workspace features for your business?

Try Google Workspace today!

If you create a custom dashboard, you can add a slicer to filter your tables, charts, or pivot tables.

To get an example spreadsheet and follow along with the video, click “Make a Copy” below.

Make a copy

Add a slicer

  1. On your computer, open a spreadsheet at sheets.google.com.
  2. Click the chart or pivot table you want to filter.
  3. At the top, click Data and then Add a slicer.
  4. At the right, choose a column to filter by.
  5. Click the slicer and choose your filter rules:
    • Filter by condition: Choose from a list of conditions or create your own.
    • Filter by values: Uncheck any data points that you want to hide. 

Delete a Slicer

  1. Click the Slicer.
    • Press Delete or Backspace.
    • Click Menu More and then Delete slicer

Notes:

  • You can use one slicer per column. To filter by more than one column, add multiple slicers.
  • Slicers apply to all charts and pivot tables in a sheet that use the same data set.
  • Slicers don’t apply to formulas in a sheet that use the same data set.
  • If you add multiple slicers that use the same source data, make sure the range of each slicer is the same as the others.
  • A slicer’s filter selections remain private and unsaved unless you set them as default.

Edit your slicer

  1. On your computer, open a spreadsheet at sheets.google.com.
  2. To change the data range, column, or title of a slicer, click the slicer you want to change.
  3. On the right side, click More Moreand then Edit slicer.

To change the filter options, click Filter Filter list.

Save your slicer filtering selections

To keep the filters you apply on your slicer after you close your spreadsheet, set them as default. If you share your spreadsheet with others, they'll see the default filters.

  1. On your computer, open a spreadsheet at sheets.google.com.
  2. On the right side of the slicer you want to make default, click More Moreand then Set current filters as default.

 

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

17779082650593148367
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false
false
false