In this article, I will show you how to retrieve data from a web page and import the data into an excel worksheet. With this function, you can prepare excel data very efficiently.

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

Excel provides an auto recover unsaved workbook feature for you to recover the unsaved excel workbook. This feature is very useful. It can save you a lot of time when you exit Excel without saving the workbook changes. This article will tell you how to use it.

Sometimes you may want to verify user input data type or value in excel cell. And excel just provide such a feature for you to customize the cell data validation process. You can define which data type and what data values are valid for one or multiple excel cells. If the data is not valid,

In this article, I will show you how to make an excel cell expand it’s width and height to fit the input text width or height automatically.