Solutions

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 »

3 Quick Ways to Remove Hyperlinks from Pictures in Your Word Document

In this article, we would like to exhibit you 3 quick ways to remove hyperlinks from pictures in your Word document. Sometimes, when copy a picture online, we find it embedded with a hyperlink. And in a Word document, accidentally clicking on the picture may lead you to the net address of the picture. This is not only irritating but messes up the visual effect of your document, such as below: Therefore, we choose to remove hyperlinks from pictures to avoid such unexpected page jump. Here...

Read more »