When you want to apply a small tweak to the document, it must not require much time to Enter dropdown diploma. Such a basic action does not have to demand extra education or running through handbooks to understand it. With the right document modifying tool, you will not spend more time than is necessary for such a swift change. Use DocHub to streamline your modifying 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 take minutes to learn to Enter dropdown diploma. The only thing needed to get more effective with editing is actually a DocHub account.
A plain document editor like DocHub can help you optimize the time you need to spend on document modifying regardless of your prior knowledge of such instruments. Create an account now and boost your efficiency instantly with DocHub!
[Music] in this lecture Im going to show you how you can use the combo box form control in your Excel report it basically looks like this so you give the user the option to click on this drop-down and they can select a month from here in this case Im returning the month in two places one is here in an Excel cell and another one is in a text box this looks very similar to the data validation feature in Excel right except that its not the same thing because the data validation feature holds those values in the cell itself in this case its holding it in the combo box object so its separate to the Excel cells Im just going to remove these and were going to do it from scratch also remove this one to insert a combo box you have to go to the Developer tab click on insert and thats the one right here is the combo box and then go anywhere in your excel sheet and just draw it out because Im just going to make it a bit smaller now right mouse click go to format control the main options