Solutions

Why Excel AutoComplete Feature Stops Working for Some Cases Mysteriously?

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 »

How to Merge Cell Styles from Other Excel Workbooks

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 »

2 Methods to Get the Difference Between Two Dates in Excel

Excel will certainly do a lot of work relating to dates. In this article, we will introduce 2 ways to get the difference of 2 given dates. To calculate the time or date difference in Excel is a very common task in Excel. For example, you may need to calculate how many days that employees have worked in the company. In this image, there are the dates of different employee that working in the company. And now you need to calculate how long that they have been in this company. The following...

Read more »