![]() For example, if other people are going to be entering data, then you are probably going to want to customize the settings marked as “optional” above. The first few times you create a dropdown list it’s likely that you will discover that there are some things you want to change. You can make changes to the drop-down list by clicking the cell to select it, then clicking the Data Validation button on the Data tab. Step 2: Type the items that you want to include in the list into a column in your spreadsheet. Step 1: Open your spreadsheet in Excel 2010. This is ideally used in situations where you are looking for a specific value or type of text to occur in a cell, and you want to avoid problems that can arise when people manually enter the values themselves. The steps in the article below will result in a drop-down list that you can click to select an option. Adding a Drop-Down List in Excel 2010 (Guide with Pictures) Our article continues below with more information and pictures for these steps. There are some other settings you can or should apply to the list, which we discuss below. Type an “=” sign, then the Name from step 2.Click the cell where the dropdown should be.Select the items, enter a name, then press Enter.Our guide below will show you how to create a drop-down list in Microsoft Excel 2010. ![]() When you have a cell that can only have a few different options, such as a month, day of the week, or even a really long option that you do not want to re-type repeatedly, then a drop-down list cannot only save you time, but also help to avoid any misspellings or typos. One good way to do this is with the inclusion of drop-down lists. If you are entering data into a spreadsheet, or if you are creating a spreadsheet for others to use, then it is typically a good idea to make everything as easy as possible. ![]() Creating a drop down list in Excel 2010 is something that seems like it should be fairly simple, as it’s a helpful item to have, and there are a lot of uses for it.īut if you’ve ever tried to make a dropdown in Excel, then you may have found that it’s a little more complicated than it seems.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |