So, if you forget the criteria you have specified to a filter, just hover the cursor over the filter icon.Ģ.2 Apply filter with multiple criteria to multiple columns (multiple criteria)Ģ.2.1 Apply filter with multiple criteria to multiple columns one by one It is very considerate that when you hover the cursor over the filter icon, the filter criteria you have specified will be displayed as a screen tip as the below screenshot shown. All you specified data are displayed and the rest are hidden.Īfter applying filter, you can see the drop down arrow turns to a filter icon. Or you can uncheck the Select All box to deselect all data, and then only check the boxes next to the data you want to show.ģ) Click the OK button to start filtering. Please go to that column, and then do as follows.ġ) Click on the drop down arrow in the column header.Ģ) Specify a comparison from the built-in operations. If you only want to apply the filter to one column, such as filter data in column C as the below screenshot shown.
2.1 Apply filter to one column (one criteria) This section is going to show you how to apply filter in one or more columns in Excel. How to apply filter in Excel (one or multiple criteria)Īfter adding the filter, you need to manually apply it. Select any cells in a range or table you want to add filter, and then press Ctrl + Shift + L keys.Īfter applying one of the above operations, you can see drop down arrows are added in the column headers of selected cells.Ģ. Select any cells in a range or table you want to add filter, click Home > Sort & Filter > Filter. Select any cells in a range or table you want to add filter, click Data > Filter. This section provides 3 ways to add filter in Excel. To filter data in a range or table, firstly you need to add filter to your data.
0 kommentar(er)
