When you want to apply a minor tweak to the document, it must not take long to Go over dropdown license. This kind of basic activity does not have to require extra training or running through guides to understand it. With the appropriate document editing instrument, you will not spend more time than is necessary for such a swift change. Use DocHub to streamline your editing process regardless if you are an experienced user or if it’s your first time making use of a web-based editor service. This instrument will require minutes or so to learn how to Go over dropdown license. The sole thing required to get more effective with editing is a DocHub account.
A simple document editor like DocHub will help you optimize the amount of time you need to spend on document editing regardless of your previous experience with this kind of instruments. Create an account now and enhance your productivity instantly with DocHub!
hi and welcome to this tutorial here Im gonna show you how to create a drop-down menu that accepts values not in the drop-down menu if youd like to get the workbook you see here go to teach Excel comm and you can download it from there alright so what Ive got here is the data validation worksheet from data validation one tutorial and weve got a sample list right here and the drop-down menu in this yellow cell right here and so I can select any one of these values and have it populate the cell also I can hit the Delete key to delete the text when it still keeps it in the drop down menu the problem however is if I want to enter something else in this cell that is not within the drop-down menu once I hit enter its going to give me the error or an error the value interred is not Val valid so then lets go ahead and make it so that we can enter other values here the reason you may want to do that is lets say your source table over here has not been updated yet so youve got a 2.5 inc