ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is the filter function in Excel?

user-image
تم إضافة السؤال من قبل Mohammad Shadab , Test Engineer , TRUFIL Limited
تاريخ النشر: 2017/04/19
SHABIL LATHEEF
من قبل SHABIL LATHEEF , Audit Assistant , suresh &saju chartered accountants

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

raheel muhammad
من قبل raheel muhammad , Team Leader , GulAhmed

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

Onuche Mark
من قبل 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
من قبل Sajin Prasannan , Accountant , VKS Jewellery Trading LLC

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

Abdelatif BENAYAD
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل Khawaja Danish Ali , accounting specialist , Goldbar Tech Pvt Ltd

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

Canice Xavier
من قبل Canice Xavier , Transaction Officer , First Bank of Nigeria Plc

it is use to arrange data for easy analysis

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟