In older formats of Excel workbooks, you cannot use some new features. Thus, here we provide two effective methods to convert the file formats.
If the format of a file is an older version, you cannot use the new features in newer version of Excel application. However, new features can save you a lot of time and energy. Therefore, in order to use the newer features, you need to convert file formats. And below are two different methods to save Excel workbooks as newer file formats.
Method 1:...
Read more »
Some blank cells in a worksheet are actually not empty. But their existence will make you confused. Therefore, you need to find those non-empty cells in your Excel worksheet.
There are many conditions that a cell will be non-empty while the content in it is invisible. For example, a formula will return null value, the font color in the cell is the same as the fill color, or the invisible values that returned by VBA macros. All those reasons can make the content invisible. But actually those...
Read more »
Someone wants to highlight the emails depending on their ages, namely how long the emails have been in their mailbox. Actually it is just based on the received date. This article will introduce a quick and easy method.
Many Outlook users desire to make specific emails to stand out. Undoubtedly, the best way is to color code the emails by conditional formatting rule. Here we will take the following case as an example. A user is afraid that Outlook auto-archive will remove useful items without...
Read more »
