Allow Mark Dropdown with airSlate SignNow

Set up dropdown warranty

hi everyone my name is Kevin today I want to show you how you can create drop-down lists in Microsoft Excel and it's full disclosure before we jump into this I work at Microsoft as a full time employee my company requires me to say that any time I talk about our products first off why would you want to create a drop-down list in Microsoft Excel well imagine that you set up a spreadsheet and you're gonna have other people filling it out perhaps you only want them to fill out a cell with specific values and a drop-down list is the perfect way to make sure that people select from those specific values it's actually very easy to set up and I'm going to show you step by step how to do it so you two can create a drop-down list all right well enough talk let's jump on the PC Here I am on my PC and I already have Microsoft Excel open this version of Excel comes with office 365 it's the latest and greatest however drop-down lists have been available as part of Microsoft Excel for a long time even if you have an older version you should be able to take advantage of this before I show you how to create drop-down lists I want to show one thing that's been added recently and that's a drop down tutorial if you click on file and then home you'll see a list of different tutorials not only will it show you how to create drop-down lists but you could also want learn how to work with formulas you get an introduction to excel you can work with pivot tables charting so there are all types of tutorials that are added as part of Excel that I'll teach you how to use it for drop down lists this is an excellent tutorial pagin that I've run a grocery store and we have all different types of food that we sell within this grocery store you can find things like apples beef and bananas what I want to do is I want my staff to come in here and indicate what department these different food items can be found in now I could rely on my department members to simply type in well you know this is this is produce or this is meter this is bakery and they could go through and type these in however what would probably happen is you have a lot of people working on a sheet you'll have people type in different things maybe they'll type it in differently from others and then we'll have all different types of values and I want to make sure that the data that's entered is valid so we list as perfect reviewing this so to create a list what we're gonna do is I have my table set up and I want people to come in here and basically select a value from a...