2 Simple Methods to Select All Non-blank Cells in an Excel Worksheet

In an Excel worksheet, if data is entered in nonadjacent cells, you may discover it a bit troublesome to select and copy the data in non-blank cells. Now, in this post, we will introduce 2 ways to quickly select all non-blank cells. Excel users are frequently required to copy and paste data. However, sometimes, there may be some troubles. For example, there are multiple discontinuous blank cells in an Excel worksheet. In this case, it is a bit hard to select all the cells which have content....

Read more »

4 Top Risks when You Run CHKDSK on Hard Drive

As we all know. CHKDSK is able to check your drives for errors. Yet, if misused, it will cause unrecoverable damage to your drives. Now, in this article, we will expose its 4 most common risks. Windows has a native disk repair tool – CHKDSK, which is really robust to detect bad sectors and fix disk errors. However, it may result in some troubles and risks when it is misused in some cases. Now, in the followings, we will unveil the 4 top risks of running CHKDSK on your drives. 1. Run...

Read more »

2 Methods to Auto Show Private Calendar Items in a Specific Color in Your Outlook

In order to distinguish private items and non-private items in calendar more easily, you may wish to auto show private items in a specific color, such as red to highlight them. This post will introduce 2 ways to realize it. Many users prefer to classify calendar items based on whether they are private or not. Since, in calendar, private items have no manifest differences in vision by default, so as to identify private items much more easily, you can let Outlook auto show them in a specific...

Read more »