Office File Recovery

How to Manually Input Texts into a Cell with Drop-down List in Excel

Some features in Excel may cause confusion to us. And here we have solved the problem with the drop-down list in Excel. In our previous article “How to Create Multiple Choice Questions in an Excel Form”, we have introduced the steps to create a drop-down list in cells. But sometimes when you input texts other than those in the drop-down list into the cell, Excel will show an error message. Below is an example: In this example, the cells in the first column have drop-down lists. And...

Read more »

How to Make Excel Charts More Intuitive by Adding Data Labels and Tables

The chart in Excel is a very fantastic feature to analyze data. And now we have two methods to make the chart more intuitive by adding corresponding numbers. In a chart, you surely will need to compare a multitude of data. Consequently, you need to come back to worksheet and confirm the matching number quite often. For example, this image is the sales volume of two different products. Although you can view the approximate number from the vertical axis, you still need to refer to the...

Read more »

3 Quick Tips to Insert Different Types of Horizontal Lines in Word Documents

In today’s article, we find out 3 easy ways to guide you when insert different types of horizontal lines in Word documents. Now and then, if you write a long Word document, you may encounter a situation where you have to add some horizontal lines. Never overlook these lines. They are often easy on the eyes so that your document will be clear and reader-friendly. Following are 3 methods for you to get different styles of lines you want. Please read on to find out the exact steps. Tip 1:...

Read more »