Scribd Logo
Upload

Welcome to Scribd!

  • 1 views

    MS_Excel_Filter_Lab1

    Uploaded by

    Israa M Alqatow

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    MS_Excel_Filter_Lab1

    Uploaded by

    Israa M Alqatow
    1 views8 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    1 views8 pages

    MS_Excel_Filter_Lab1

    Uploaded by

    Israa M Alqatow

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 8

    Course Name: Introduction to IT Lab

    Topic: MS-Excel (Filter)

    L EC T UR ER: E N G. I S R AA A LQATOW
    DEPARTMENT OF I NFORMATION TECHNOLOGY
    OBJECTIVES
    Use AutoFilter or built-in comparison operators like "greater than" and
    “top 10” in Excel to show the data you want and hide the rest.
    Once you filter 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.
    Filter Data
    Use filters to temporarily hide some of the
    data in a table, so you can focus on the
    data you want to see.
    Filter a range of data
    1- Select any cell within the range.
    2- Select Data > Filter.

    3- Select the column header arrow.


    Filter a range of data
    4- Select Text Filters or Number Filters, and then select a comparison,
    like Between.

    You can search about an


    item in your sheet using
    the Windows search
    command i.e. using (*,?)
    Filter a range of data
    5- Custom Filter -> Enter the filter criteria and select OK.
    Filter data in a table
    When you put your data in a table, filter controls are automatically
    added to the table headers.
    Filter data in a table
    1- Select the column header arrow for the column you want to
    filter.

    2- Uncheck (Select All) and select the boxes you


    want to show.

    3-Click OK.
    The column header arrow changes to
    Filter icon. Select this icon to change or
    clear the filter.

    You might also like