Filter

Filter helps you quickly display records that meet specific criteria in large datasets while hiding rows that do not match. It provides the tools you need to review and analyze data more efficiently, making your work more efficient and helping you accomplish tasks with ease. With Filter, you can enable standard filtering or Advanced Filter from a selected cell in a data range, apply criteria in a dialog box, use filtering across multiple columns at the same time, copy only visible filtered results, and cancel filtering when needed. Whether you're narrowing down large tables for viewing, analyzing matching records, or working with visible results after filtering, Filter helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.