Using defined name in Excel can save you a lot of time. Here we will introduce two methods to automatically update the reference range of a defined name in the worksheet.
A defined name has a wide range of use. You can even use a certain name in formulas. The defined named can help you increase your work pace. Sometimes you will certainly add new items into the source range of this name. However, the reference range in the name will not update automatically. In order to solve this problem,...
Read more »
The drop-down list in data validation is a frequently used feature in Excel. In this article, we will introduce two methods to auto refresh the drop-down list.
In our previous article How to Create Drop-down List from a Range of Cells in Your Excel, we have introduced the drop-down list in detail. When the source range changes, the drop-down list will also be affected. Whenever you add or delete an item in the range, you need to check the drop-down list in the target cell. And this can be...
Read more »
Sometimes you will need to list all the file names in a folder in an Excel worksheet. Thus, you can better manage those files. In this article, we will introduce two effective methods to copy the list in a folder.
In an Excel worksheet, you can make a menu of some important files. And you need to copy the list of all the file names into one worksheet. However, when there are hundreds or thousands of files, you will find it hard to do this. In the image below, you can see several...
Read more »
