Resources

How to filter as you type with VBA in Excel

How to filter as you type with VBA in Excel

Excel has rich resources on filtering as expected from a spreadsheet software. However, the functionality may lack fanciness in a business software, like filtering on-the-fly as users are typing. Fortunately, Excel has enough customization tools to add such a feature...

How to filter as you type without VBA in Excel

How to filter as you type without VBA in Excel

Excel has rich resources on filtering as expected from a spreadsheet software. However, the functionality may lack of fanciness in a business software, like filtering on-the-fly as users are typing. Fortunately, Excel has enough customization tools to add such a...

How to enable grouping in Excel

How to enable grouping in Excel

Excel's Grouping or "outline" is a fancy feature to wrap up and summarize data in a compact view. It is a common scenario that you may see the button are greyed out. In this article, we are going to show how to enable grouping in Excel. Shared workbooks A shared...

How to filter a table based on another in Excel

How to filter a table based on another in Excel

Although Excel has a handful advanced filtering feature to filter by multiple criteria, it is not dynamic and may require complex prep work. On the other hand, the FILTER function can give the dynamic approach you need. However, establishing logical rules can be hard...