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 »
Have you ever attempted to forward all the emails in a specific conversation? It will be quite troublesome if you search and forward them in normal manner. Here we’ll introduce you 2 methods to quickly find and batch forward them.
If you are a regular Outlook user, you must have communicated with others via emails back and forth. In the process, many emails threads will come into being. Also, there is a common case that sometimes you may be required to forward an entire email thread to...
Read more »
In this article, we will offer you 3 quick and effective ways to recheck both the spelling and grammar of your Word document.
The “Spelling and Grammar” checker in Word is absolutely a huge helper for us. Word flags out any spelling and grammar mistakes it detects. We can benefit a lot from the feature. However, when we do the check through our document, especially a long one, we tend to click “Ignore” to skip some points, for there may be stuff like codes on our document.
Demand for...
Read more »
