Previously we have introduced a method of auto completing drop down list when enter the first letter into the drop down box.
#Get activex work on protected cell how to
But if the list data you need for the data validation locates in another workbook, what would you do? In this tutorial, you will learn how to create a drop fown list from another workbook in Excel in details.Ĭreate a searchable drop down list in Excelįor a drop down list with numerous values, finding a proper one is not an easy work.
It is quite easy to create a data validation drop down list among worksheets within a workbook. This tutorial provides the method to solve the problem.Ĭreate drop down list from another workbook in Excel If there is method for allowing to auto complete when typing the first letter in the drop down list, everything will become easier. If you have a data validation drop down list with large values, you need to scroll down in the list just for finding the proper one, or type the whole word into the list box directly. And all of them can still be used after protecting the worksheet.Īutocomplete when typing in Excel drop down list Now all cells with drop down list in current worksheet are unlocked. In the Format Cells dialog box, go to the Protection tab, uncheck Locked box, and then click the OK button. Right click on them and select Format Cells in the right-clicking menu. Then all cells with drop down list are selected immediately in current worksheet. Please click Find & Select > Data Validation under Home tab.Ģ. Firstly, you need select all cells with drop down list in the worksheet you need to protect. Use drop down list in a protected worksheet in Excelġ. In this article, we will show you how to select all cells with drop down list and unlock them at once to make it unable after protecting the worksheet. If you still want to use the drop down list in a protected worksheet, you need to unlock these cells before protect the worksheet.
Normally, no changes can be made in a protected worksheet while using Excel. How to use drop down list in a protected worksheet in Excel?