Drop down list excel free text
How to Manually Input Texts into a Cell with Drop-down List in Excel Leave a Comment Data Recovery, Excel File Recovery, Excel Solutions, File Recovery, Office Solutions, Solutions October 11, 2016 Share Now: Some features in Excel may cause confusion to us. And here we have solved the problem with the drop-down list in Excel. Show 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 now you want to input the season into it. However, when you created the list, the season element is not included in the list. Thus, you will see the following window if you enter the Season 1 into the cell. And now we will show you how to solve this problem. InputText into the Cell with Lists
Delete the ListThe above method will keep the list in the cell. And if you dont want to keep it, you can also delete the drop-down list. Instead of delete the list in the Data Validation window, here we will introduce an easier way.
Drop-down List cannot Survive in Data DisasterEven if the drop-down list is a small feature in Excel, it still has the danger of being destroyed. As a result, the Excel corruption will cause inconvenient to your work. Sometimes worse result will also appear. Hence a third party Excel repair tool can be a good choice for you. It can help you overcome obstacles and protect your precious information. Author Introduction:Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com Share Now: |