Office File Recovery

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 Create a Dependent Dropdown List in Your Excel Worksheet

We have introduced many useful tips about the dropdown list in our previous articles. And here we will introduce the method of creating a dependent dropdown list in your worksheet. The dependent dropdown list can be very helpful when there is a bunch of information in your worksheet. When you choose an item from the dropdown list in a cell, the items in another dropdown list will change the category accordingly. Thus, your work will be more convenient. Below are the steps on how to create...

Read more »

5 Ways to Get the Total Editing Time Spent on Your Word Document

In today’s article, we want to show you 5 ways to view and get the idea of how much time you’ve spent on your Word document. From time to time, you may have to work on a quite long document. And when it finishes, you might want to know the exact time you have devoted to processing it. In view of such a demand, we here list 5 easy ways for you to check the total editing time of a very document. Method 1: Switch to the Backstage View Firstly, click “File” tab. Then go to the...

Read more »