REMOVEFILTERS

Formulas / REMOVEFILTERS
Clear the filters from a table.
=REMOVEFILTERS([ | [, [, [,…]]]])
  • table - the table to clear filters from
  • column - the column to clear filters from
  • column - [OPTIONAL] the column to remove filters from

Examples

  • REMOVEFILTERS(A1:A10)

    The function can be used to remove all filters from a cell range. For example, this removes any filters that have been applied to the cell range A1:A10.

  • REMOVEFILTERS(A1:A10, "color")

    The function can also be used to remove a single filter from a cell range. For example, this removes any color filters that have been applied to the cell range A1:A10.

  • REMOVEFILTERS(A1:A10, "color", "date")

    The function can also be used to remove multiple filters from a cell range. For example, this removes any color and date filters that have been applied to the cell range A1:A10.

  • RANK.AVG(94, REMOVEFILTERS(B2:B8))

    The function can also be used in combination with other functions. For example, this finds the rank of the value 94 in the cell range B2:B8 and returns 4 because the temperature reached 94 on July 5, 2011, which was the 4th hottest day of the days listed.


Summary

The REMOVEFILTERS function is used to remove all filters applied to a specified table or column, allowing users to view the entire data set without any filtering. This function is particularly useful when working with large data sets where filters have been applied to narrow down the data, and users want to quickly clear those filters to see the full data set again.

  • REMOVEFILTERS can be used to remove filters from a table.
  • Applying filters to a table can help you quickly find and analyze data.
  • You can use the REMOVEFILTERS function to remove the filters and restore the table to its original state.

Frequently Asked Questions

What is the REMOVEFILTERS function?
The REMOVEFILTERS function is used to remove filters from a table.
What should I be cautious of when using REMOVEFILTERS?
When using the REMOVEFILTERS function, it is important to note that it does not return a table.
What are some recommended practices when using REMOVEFILTERS?
  • Always check the table before and after you use the REMOVEFILTERS function.
  • Consider making a backup of the table before using the REMOVEFILTERS function.
  • When in doubt, consult with someone who is knowledgeable about the function.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV