Google serves cookies to analyse traffic to this site. Information about your use of our site is shared with Google for that purpose. This website uses cookies so that we can provide you with the best user experience possible.
Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful. Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings. If you disable this cookie, we will not be able to save your preferences.
This means that every time you visit this website you will need to enable or disable cookies again. Toggle navigation. Click in the Refers to box, and then on your worksheet select all of the cells that contain the entries for your drop-down list.
Tip: If you don't know what a named range is named, you can select the range and look for its name in the Name Box. To locate a named range, see Find named ranges. On the worksheet where you applied the drop-down list, select a cell that has the drop-down list.
On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, select all of the cells containing those entries. You'll see the list range in the Source box change as you select. To update all cells that have the same drop-down list applied, check the Apply these changes to all other cells with the same settings box.
On the Settings tab, click in the Source box, and then change your list items as needed. Each item should be separated by a comma, with no spaces in between like this: Yes,No,Maybe.
After you update a drop-down list, make sure it works the way you want. For example, check to see if the cell is wide enough to show your updated entries. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet. For more information about how to protect a worksheet, see Lock cells to protect them. If you want to delete your drop-down list, see Remove a drop-down list.
To see a video about how to work with drop-down lists, see Create and manage drop-down lists. On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, Select cell contents in Excel containing those entries. For example, check to see how to Change the column width and row height to show your updated entries. She has written education and document design articles for eHow.
Regardless of how old we are, we never stop learning. Classroom is the educational resource for people of all ages. Based on the Word Net lexical database for the English Language. Select the cells with the drop-down list. Click OK. Need more help? Expand your skills. Get new features first. A subscription to help make the most of your time.
For up to 6 people. Premium apps. Try 1 month free.
0コメント