Solutions

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 »

2 Methods to Insert Checkboxes into Your Outlook Emails

If you would like to include a small survey in the message body of an Outlook email, you will definitely wish to insert checkboxes. This article will introduce 2 simple workarounds. When it comes to carrying out a survey in Outlook, “Vote” feature will be the best choice. With regard to “Vote”, you can refer to another article – “Skillful Use of MS Outlook for Voting”. But if you hope to design a questionnaire directly in message body, which should include checkboxes, you can...

Read more »