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 »
The cell styles can help us identify data and information better. And in this article, we will discuss about how to use customized cell styles that created and stores in other workbooks by merging styles.
In our previous article How to Customize and Use Your Own Cell Styles in Excel, we have introduced about customizing and saving cell styles. However, you may find that if you open another workbook and want to use a certain style, you cannot find it. That is because the style that you save...
Read more »
When you need to send a contact, you may send it as an email attachment. But at times, the recipient cannot open the contact in VCard/MSG format. So why not insert the contact details into the email body directly? This article will teach you 2 ways to accomplish it.
When sending multiple Outlook contacts, sending them as email attachments will be much more recommended. However, if you just wish to send one contact, so as to avoid that recipient cannot open the contact, you had better insert...
Read more »