Register now or log in to join your professional community.
It allows us to view specific rows in sheet, while hiding the other rows.
Using AutoFilter or built in comparison operators such as "greater than" and “top 10” can show the data you want and hide the rest. Once you have filtered data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
The basic Excel filter (also known as the Excel Autofilter) allows you to view specific rows in an Excel spreadsheet, while hiding the other rows.
The Filter function in excel allows user to filter through column and row data
THROUGH THIS FUNCTION WE CAN ACCESS THE DATA IN A SPECIFIED RANGE
