How to Freeze Panes in Excel (Rows and Columns)

How to Freeze Panes in Excel (Rows and Columns)

Navigating through extensive data in Excel can be a daunting task, especially when trying to keep track of rows and columns. The abundance of information might lead to confusion, making it challenging to identify specific cells within your dataset. Fortunately, Excel...
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 extract data from a website in Excel

How to extract data from a website in Excel

Excel's extracting data capability is not a new thing. However, it has become more flexible with Power Query. In this guide, we're going to show you how to extract data from a website in Excel. Download Workbook Extracting data from a website in Excel by using Power...
How to get rid of Microsoft has blocked macros message in Excel

How to get rid of Microsoft has blocked macros message in Excel

If you ended up in this article, you should have already seen the message "Microsoft has blocked macros from running because the source of this file is untrusted." Microsoft has recently started to show this message in Office products when users open a file that came...
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 show hidden data in chart in Excel

How to show hidden data in chart in Excel

If you wonder why your graphs vanish after you hide or filter data, you are in the right place. In this guide, we’re going to show you How to show hidden data in chart in Excel. Download Workbook Why does a chart not show hidden data? This is a feature and default...
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...
How to use absolute references with Excel Tables

How to use absolute references with Excel Tables

If you ended up in this article, it's a big probability that you had referred a column or cell in your Excel table and press F4 and finally heard the annoying chime. Fortunately, you haven't given up and made manual changes on the references. In this guide, we’re...