Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the filter function in Excel?

user-image
Question ajoutée par Mohammad Shadab , Test Engineer , TRUFIL Limited
Date de publication: 2017/04/19
SHABIL LATHEEF
par SHABIL LATHEEF , Audit Assistant , suresh &saju chartered accountants

allows to view specific rows in excel spread sheet , while hiding other raws

raheel muhammad
par raheel muhammad , Team Leader , GulAhmed

First click on the range of cells that you want to filter.

Onuche Mark
par Onuche Mark , Registration Supervisor-Admission Officer , Skyline University Nigeria

It allows you to be specific in what you are doing in the excel

Sajin Prasannan
par Sajin Prasannan , Accountant , VKS Jewellery Trading LLC

It allows us to view specific rows in sheet, while hiding the other rows. 

Abdelatif BENAYAD
par Abdelatif BENAYAD , Marketing Consultant , D-AIM pour OOREDOO Algérie

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.

Shoaib Qureshi
par Shoaib Qureshi , Assistant Manager , Sarena Apparel

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. When the Excel autofilter is added to the header row of a spreadsheet, a drop-down menu appears in each cell of the header row.

Ravi Kumar
par Ravi Kumar , Site Accountant , Royal Infraconstru Ltd

Using AutoFilter to filter data is a quick and easy way to find and work with a subset ... slicers were added as a new way to filter PivotTable data. In Excel ...

jyothi acharya
par jyothi acharya , accountant , Emitac Healthcare Solutions

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.

Ria Theresa Teodoro
par Ria Theresa Teodoro , CREDIT ANALYST , Liberty Commercial Center

The Filter function in excel allows user to filter through column and row data

Khawaja Danish Ali
par Khawaja Danish Ali , accounting specialist , Goldbar Tech Pvt Ltd

THROUGH THIS FUNCTION WE CAN ACCESS THE DATA IN A SPECIFIED RANGE

Canice Xavier
par Canice Xavier , Transaction Officer , First Bank of Nigeria Plc

it is use to arrange data for easy analysis

More Questions Like This