Office File Recovery

2 Methods to Auto Refresh the Drop-Down List in Your Excel Worksheet

The drop-down list in data validation is a frequently used feature in Excel. In this article, we will introduce two methods to auto refresh the drop-down list. In our previous article How to Create Drop-down List from a Range of Cells in Your Excel, we have introduced the drop-down list in detail. When the source range changes, the drop-down list will also be affected. Whenever you add or delete an item in the range, you need to check the drop-down list in the target cell. And this can be...

Read more »

How to Show the Data Changes in Win/Loss Sparklines in Your Excel

You will certainly analyze the change of data in your Excel worksheet. Today, we will show you how to use the win/loss sparklines chart to analyze data. The data in the worksheet need to be deeply analyzed. And you can use many methods in Excel to analyze data. In our previous article Sparkline - Mini Chart to Show Data Trends in Your Excel Worksheet, we have introduced the line sparklines in detail. And now we have found that the win/loss sparklines in Excel can also show the data...

Read more »

3 Quick Ways to Recheck Both the Spelling and Grammar of Your Word Document

In this article, we will offer you 3 quick and effective ways to recheck both the spelling and grammar of your Word document. The “Spelling and Grammar” checker in Word is absolutely a huge helper for us. Word flags out any spelling and grammar mistakes it detects. We can benefit a lot from the feature. However, when we do the check through our document, especially a long one, we tend to click “Ignore” to skip some points, for there may be stuff like codes on our document. Demand...

Read more »