Posts Tagged 'Excel tips'

How to Auto Update the Sequence Numbers in Your Excel Worksheet

The sequence numbers can always be seen in an Excel worksheet. In this article, we will show you how to auto update the sequence numbers when you insert or delete rows in a range. You will certainly have used the sequence numbers in a worksheet. With those numbers, the range will be clearer and you can manage your data and information better. When you insert a new row or delete a row in the range, the sequence numbers will be discontinuous. And you need to update the numbers. It will be...

Read more »

2 Methods to Auto Update the Reference Range of a Defined Name in Excel Worksheet

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 »

How to Copy the List of All File Names in a Folder into Excel Worksheet via VBA

Collecting all the file names in a worksheet is very important to your work. In this article, we will introduce a method to input all the file names into a worksheet by using VBA macro. In our previous article 2 Methods to Copy the List of All File Names in a Folder into Your Excel Worksheet, we have introduced two methods to list all the file names in a folder into a worksheet. And now we have found another method. You can also use the VBA macro to finish this task. Follow the steps below...

Read more »