6 Ways to Test If Your Hard Drive Is Bad or Not

You should take good care of your hard drive in that if it fails, your data will surely suffer. Also, you need to test your hard drive regularly, namely checking if it is bad or not. Now, this article will expose 6 approaches to test it. It is known that a bad hard drive can result in all kinds of issues. For instance, if it is an internal hard drive, your computer will tend to malfunction, such as errors when reading, copying or deleting data, pretty poor PC performance, unbootable PC...

Read more »

How to Auto Adjust Combo Box or List based on Dynamic Data Ranges in Excel

Where data downloaded from a database exceeds a combo box’s range, the new items are simply not shown. To counter this, the range that underlies List or Combo boxes needs to expand or contract to match the data.  This article examines how to do this automatically.  It is assumed the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google “Excel Developer Tab” or “Excel Code Window”. A professional way of displaying combo boxes is to...

Read more »

3 Ways to Batch Remove the Fill Color of Multiple Shapes in Your Word Document

In this post, we are glad to show you 3 effective methods to batch remove the fill color of multiple shapes in your Word document. While inserting shapes into a Word document, you may apply fill color to them as well. It’s easy to add or remove the fill color of a single shape. But when it comes to batch processing, we will need some trick. This time, we want to show you how to batch remove the fill color of multiple shapes in document. So you can refill them with desired colors or...

Read more »