How to Filter in Excel Archives

How to Filter Email Addresses in Excel (5 Easy Ways)

May 18, 2023

Email addresses are an important way of communicating in today's digital world. Excel, a popular spreadsheet program, can be an effective tool for ...

How to Filter Email Addresses in Excel (5 Easy Ways)

How to Hide Filter Buttons in Excel

May 10, 2023

We often use Excel to maintain databases in our day-to-day life. In some cases, we need to filter our data based on specific conditions. This can be ...

Excel VBA: Filter Table Based on Cell Value (6 Easy Methods)

Feb 9, 2023 2

The AutoFilter function is one of several Excel features that may also be utilized in VBA. If you have a dataset and wish to filter it based on a ...

Excel VBA: Filter Table Based on Cell Value (6 Easy Methods)

How to Remove Filter in Excel VBA (5 Simple Methods)

Feb 27, 2023

While working with Microsoft Excel, filtering data allows us to see only the information that we want. Whenever we want to concentrate on certain ...

How to Remove Filter in Excel VBA (5 Simple Methods)

How to Filter Multiple Columns by Color in Excel (2 Methods)

Feb 9, 2023

In this article, I will discuss how you can filter multiple columns by color in Microsoft Excel. Usually, when we filter a certain column, other ...

How to Filter Multiple Columns by Color in Excel (2 Methods)

How to Filter Multiple Values in One Cell in Excel (4 Methods)

Mar 1, 2023

While working with large Microsoft Excel, sometimes we need to filter multiple values in one cell. Filtering data is more important in Excel. We can ...

How to Filter Multiple Values in One Cell in Excel (4 Methods)

Excel VBA to Filter in Same Column by Multiple Criteria (6 Examples)

Feb 13, 2023 2

In this tutorial, we will demonstrate the use of excel VBA to filter in the same column by multiple criteria. In Microsoft Excel using VBA to filter ...

Excel VBA to Filter in Same Column by Multiple Criteria (6 Examples)

How to Remove Filter by Color in Excel (5 Methods)

Oct 19, 2022

It’s better to apply Filter by Color when we desire to sort data color-wise in Excel. However, at times, we need to remove Filter by Color in Excel ...

How to Remove Filter by Color in Excel (5 Methods)

How to Filter by List in Another Sheet in Excel (2 Methods)

Feb 9, 2023

The FILTER function allows us to filter a set of data based on a set of criteria. Filtering data based on a list in another worksheet is also ...

How to Filter by List in Another Sheet in Excel (2 Methods)

VBA Code to Filter Data in Excel (8 Examples)

Feb 27, 2023

Excel Sort & Filter command has a limited range to Filter data. But using VBA you can Filter data in a wide range as you wish. This article will ...

VBA Code to Filter Data in Excel (8 Examples)

Excel VBA: Filter Based on Cell Value on Another Sheet (4 Examples)

Feb 16, 2023 4

This article illustrates 4 different examples to filter a dataset based on a cell value that is on another sheet using VBA code in Excel. We’ll use ...

Excel VBA: Filter Based on Cell Value on Another Sheet (4 Examples)

Filter Different Column by Multiple Criteria in Excel VBA

Feb 27, 2023 2

The article will provide some different methods on how to Filter multiple criteria in a different column(s) in Excel VBA. Here we have a dataset ...

Filter Different Column by Multiple Criteria in Excel VBA

How to Use Filter in Protected Excel Sheet (With Easy Steps)

Feb 9, 2023 2

This article illustrates how you can allow people to use filter in your protected excel sheet. You may need to do this to create a user-friendly ...

How to Use Filter in Protected Excel Sheet (With Easy Steps)

How to Filter Column Based on Another Column in Excel (5 Methods)

Jan 29, 2023

In this article, we’re going to show you 5 methods of how to use Excel to Filter a column based on another column. To demonstrate these methods, ...

How to Filter Column Based on Another Column in Excel (5 Methods)

How to Filter Based on Cell Value Using Excel VBA (4 Methods)

Feb 27, 2023 2

When you have a larger dataset and you want to apply the filters based on a certain value, using the VBA code might be the best option. In this ...