2 Effective Methods to Fill Your Excel Worksheet with Gradient Color

If you can use gradient color in your work, you are sure to improve your work efficiency. In this article, we will introduce two methods to fill your worksheet with gradient color. It is very easy for you to fill a cell or a range with a certain color. Besides, you can also fill gradient color in a cell. However, there is no direct way in Excel to fill a range with gradient color. Now we have found two methods to finish this task. Method 1: Insert Background In this method, you can insert...

Read more »

2 Methods to Count the Number of Recipients in an Outlook Email

At times, you may want to calculate the total number of the recipients in a specific email. But Outlook has no obvious “counting” function to support it. So this article will introduce 2 approaches to achieve it. In some situations, for instance, when you’ve added a great amount of recipients to an email and find it difficult to manage them, you would like to obtain the total number of these recipients. But Outlook doesn’t have a native or default support to count. Thus you have to make some...

Read more »

How to Insert a Future or Past Date in Your Word Document via VBA Codes

In this article, we will show you an interesting trick to insert a future or past date in your Word Document via VBA codes. Generally, we have no difficulty in inserting a current date in our Word document. Yet, now and then, we could be preparing for the document needed next week or month or even later. Then here is the problem you can’t bypass. How can you insert a future date in Word file? And sometimes how about a past one even? It is therefore we think you must grasp this useful...

Read more »