Filter Worksheet data

Filter Worksheet Data

Excel worksheets typically contain a lot of data that sometimes cannot be displayed on the screen at one time. Filtering data will help to limit the data displayed in the worksheet based on certain criteria

TIP When filtering data in the worksheet, you should format headers to stand out from the data, such as making them bold and center aligning them so that Excel can identify headers versus the data of the list

Filter columns

1.   Click any cells in the range or table that you want to filter

2.   Do one of the following:

• From the Toolbar, click Filter icon

• From the Ribbon, click Data tab go to Sort & Filter group and click Filter

3.   Excel displays the Filter buttons  at the right edge of the header cells, click the arrow  in the column that contains the content that you want to filter and select a desired filtering criteria

 

Create a selection filter

In the Filter section, do the following

1.   Click any cells in the range or table that you want to filter

2.   Do one of the following:

• From the Toolbar, click Filter icon

• From the Ribbon, click Data tab, go to Sort & Filter group and click Filter

 

3.   Excel displays the Filter buttons at the right edge of the header cells, click the arrow  in the column

4.   In the Filter section, do the following

• Deselect Select All check box

• Select a desired selection by clicking the check box

5.   When a filter has been applied to a column, the black down arrow will change to a filter icon that looks like a funnel

NOTE     When Excel performs a selection filter, other data which doesn’t meet the criteria is not gone but it is just hidden. You can tell that rows have been hidden by looking at the row headers on the left where you can see the blue number displayed in the row headers. Those row numbers aren’t in sequence

  

Remove a filter