Excel Tutorial

How To Import Filtered Excel Rows From One Excel File To Another Dynamically

This article will tell you how to import filtered excel rows from one excel file into a new excel workbook. And when the source excel rows data is changed, the data in new excel workbook will also be changed dynamically by refresh the connection. There are two method to achieve this, i will introduce them …

How To Import Filtered Excel Rows From One Excel File To Another Dynamically Read More »

How To Remove Hyperlink Automatically In Excel

When you copy or input a url or an email address text into the excel cell, it will add a hyperlink automatically. Sometimes this is useful, but for most times this is not useful at all. This article will tell you how to remove the hyperlink and how to disable auto hyperlinking in excel settings.

How To Filter Excel Rows By Multiple Customized Condition

Microsoft Excel provides a filter function for you to find out required rows by the customized condition in a very long excel worksheet. The filter feature includes a basic filter that provides simple condition filtering and an advanced filter that provides complex condition filtering. This article will show you both the 2 filter features with …

How To Filter Excel Rows By Multiple Customized Condition Read More »