![]() Ensure Ignore blank and In-cell dropdown are checked. Under the Settings tab, in the Allow drop down menu click List. The Data Validation Dialog Box will appear. Go to the Data Tab on the ribbon and on the Data Tools group, choose Data Validation.ģ. This is the cell that is going to have the drop down list. This sheet is called ProductsDropDownList in our example.Ģ. In this case, this is the destination sheet where you would like the drop down list to be. This is the original sheet that contains the source data.ġ. In the example below, we have a worksheet called Products containing the names of products. We will cover everything about how you can make a drop down list here.Ĭreate A Drop Down List Using A Cell Range They help you to streamline the experience you are creating for your users, and design a smooth looking document for them to use. Whenever you create an Excel spreadsheet for a user to input data, a drop down list will be very helpful! How to create a drop down list in Excel, is covered in our Advanced Excel training course.ĭrop down lists help you to organise your data and limit the amount of entries people can make to each cell. When you are creating a dropdown list Excel allows you to tailor it to your needs in a variety of ways.Īn Excel drop down list is comparable to the dropdown menus that one often sees on forms or webpages. This is also a great way to ensure that only valid data is entered into a cell. These types of lists are great for user input. You can easily allow users to choose an item from a pre-defined list, by using a dropdown list in Excel. You can always ask an expert in the Excel Tech Community or get support in Communities.We have all used tables in Excel, but what if you are looking to make this table into a list for others to use? To delete a drop-down list, see Remove a drop-down list. If you decide you want to change the options in your drop-down list, see Add or remove items from a drop-down list. For example, you might want to check to see if Change the column width and row height to show all your entries. If you don’t want a message to show up, clear the check box.Īfter you create your drop-down list, make sure it works the way you want. If you want a message to pop up when someone enters something that's not in your list, check the Show Alert checkbox, pick an option in Type, and type a title and message. If you don’t want a message to show up, clear the check box. If you want a message to pop up when the cell is selected, check the Show message checkbox, and type a title and message in the boxes (up to 225 characters). You can also just type a list of entries in the Source box, separated by a comma like this: Just include the cells that should appear in the drop-down. If you already made a table with the drop-down entries, select in the Source box, and then select and drag the cells that contain those entries. Go to the Data tab on the Ribbon, then select Data Validation. Select the cell in the worksheet where you want the drop-down list. Now is a good time to Sort your data in the order you want it to appear in your drop-down list. Why should you put your data in a table? When your data is in a table, then as you add or remove items from the list, any drop-downs you based on that table automatically update. To stop people from entering data that isn’t in the drop-down list, select Stop. Information will show a message with this icon and Warning will show a message with this icon. To show a message that doesn’t stop people from entering data that isn’t in the drop-down list, select Information or Warning. Not sure which option to pick in the Style box? ![]() If you want a message to pop up when someone enters something that's not in your list, check the Show error alert after invalid data is entered box, pick an option from the Style box, and type a title and message. ![]() If you want a message to pop up when the cell is selected, check the Show input message when cell is selected box, and type a title and message in the boxes (up to 225 characters). ![]() If it’s OK for people to leave the cell empty, check the Ignore blank box. Note that we left out the header row, because we don't want that to be a selection option: We put ours on a sheet called Cities, in range A2:A9. Select in the Source box, then select your list range. On the Settings tab, in the Allow box, select List. Unlock specific areas of a protected workbook or stop sharing the worksheet, and then try step 3 again. Note: If you can’t select Data Validation, the worksheet might be protected or shared. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |