Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the filter function in Excel?

user-image
Question added by Mohammad Shadab , Test Engineer , TRUFIL Limited
Date Posted: 2017/04/19
SHABIL LATHEEF
by SHABIL LATHEEF , Audit Assistant , suresh &saju chartered accountants

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

raheel muhammad
by raheel muhammad , Team Leader , GulAhmed

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

Onuche Mark
by 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
by Sajin Prasannan , Accountant , VKS Jewellery Trading LLC

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

Abdelatif BENAYAD
by 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
by 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
by 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
by 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
by 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
by Khawaja Danish Ali , Manager Admin and Finance , Amber Chemical Industries(Private) Limited

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

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

it is use to arrange data for easy analysis

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.