Office File Recovery

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 Useful Tips to Use Formula More Efficiently in Your Excel

You will certainly use formulas in Excel worksheets to help your work. And today we will introduce two useful formula tips for you to use formula more efficiently in your excel. When you need to use Excel formulas frequently, you’d better know some tips. Mastering those tips can help you improve your work efficiency. In the following two parts, we will introduce two useful formula tips. Tip 1: Use F4 Button In a formula, you all know that you need to choose the absolute reference or the...

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 »