This article will mainly focus on showing you to insert a picture which can automatically update itself in Word document.
Inserting picture into Word document has been a common tip for users to make their file attractive. However, when you modify the picture, the one you insert into Word file fails to update accordingly. So you may have to delete the original image and insert the new one into your Word file again. This is definitely not a pleasing way to conduct your work. Therefore we will...
Read more »
This article will demonstrate you how to remove the formatting of pasted text with macro and VBA in your word.
It happens a lot when you copy a text online, and you find the text is in rich formatting. For instance, there are repeating words, blank lines, tab characters, etc. Yet, such formatting can be quite annoying especially at times you don’t need. Naturally, you would remove the formatting manually each by each. However, what if the text is a really long one? Then the above method will...
Read more »
In Excel, you can use the icon sets to mark cells with different values. And in this article, we will talk about how to use this feature in Excel.
Icon sets is a very useful feature in Excel. It is also a small feature of the conditional formatting. Suppose now you need to mark cells for the sales volume in the worksheet.
Instead of ranking cells, now you can also use the different icons to mark different values in the cells, with icon sets, so to make these values more intuitive, as...
Read more »
