Let's learn IT

Hello again guys and welcome to another tutorial where this time  I'm going to guide you on how to create a very simple  drop down function in Excel. In this beginners tutorial we are going to use a simple stock guide for some of the products and once we're finished with this tutorial you can go ahead and create a drop down function based on your needs.     1. The first thing you should do is create your product list and fill the cells under that category. Now that you have done that go on another cell and create a table containing the list that you wish to be shown under the drop down function.  After you've done all the steps, head over to Data > Data Validation where a window will appear under the Data Validation category.     2.  Next, under Allow select List  for the validation criteria to be in function. Now, under source select the table icon as seen on the picture below.   ...