When you want to apply a small tweak to the document, it must not require much time to Change dropdown contract. This sort of basic activity does not have to require additional education or running through handbooks to understand it. With the appropriate document modifying tool, you will not spend more time than is necessary for such a quick edit. Use DocHub to simplify your modifying process regardless if you are an experienced user or if it is your first time using a web-based editor service. This tool will require minutes or so to learn how to Change dropdown contract. The sole thing needed to get more effective with editing is actually a DocHub profile.
A simple document editor like DocHub can help you optimize the amount of time you need to devote to document modifying irrespective of your prior knowledge of this kind of instruments. Create an account now and improve your productivity instantly with DocHub!
welcome to excel metric number 481 hey if you want to download this workbook and follow along click on my youtube channel then click on my college its that link and you can download the workbook excel my script 41 to 483 and this trick here we want to were going to put something in this cell multiply divide plus or minus and have it changed the actual formula so if we put a 1 here we want our formula say that cell times this one however if that would be if theres a 1 there if theres a 2 there we want it to automatically switch to divide alright the first thing is why dont we go ahead and put data validation with the numbers 1 2 3 so we can simply use a drop down right here Im going to use the keyboard shortcut for data validation alt DL we dont want to allow any value we want to allow a list now usually we click and have a source but you dont have to do that you type anything you want here separated by comma so Im gonna put 1 comma 2 comma 3 comma 4 ok now I can select whatev