Outlook supports you to design forms, no matter the message, task, appointment or contact form. Have you ever wanted to create a drop-down list in the default forms? This article will take Contact form as an example and teach you to create a custom drop-down list.
When I create new contact, I tend to input the relationship with this contact, such as colleague, superior, friend, relative and others. In the past, I just created a new custom field called as “Relationship”, like the following...
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 »
In Excel, you will find that sometimes the autocomplete of cell values will not work. And in this article, we will dig out the reason.
In Excel, sometimes you need to enter duplicate contents into a column repeatedly. In such a case, AutoComplete feature in Excel will save your time. Whenever you input the first character of an existing string, Excel will complete the remaining for you automatically.
A Case when AutoComplete Works
In this image, you can see that we have already input the...
Read more »