![]() ![]() Combo Box vs Drop-Down List in Microsoft Word Select the option you want and it’ll be recorded as your response in the drop-down list. Once a drop-down list is added to the document, you can click the down arrow on the right side of the menu to reveal the picker. When you’re done making changes, click OK to close the dialog box. The Remove button will allow you to get rid of a few options from the drop-down menu, and you can use the Move Up or Move Down buttons to change the order of various options. If you make a mistake, you can click Modify to change the text in any of your options. Your additions will appear below the Display Name sub-head. You can click the Add button to key in each option to the drop-down list. Finally, the Drop-Down List Properties section is the most important one. In the Locking section, you can choose if you want to allow the drop-down list to be edited or deleted. ![]() If you enable this, the drop-down list will automatically change to normal text when an option is selected. The option labeled Remove content control when contents are edited is an important check box in the Content Control Properties window. A subtle color works best for most people because the drop-down menu shouldn’t take attention away from other parts of the Word document. ![]() You can add a title, a tag, and pick the design and color of the box first. You can always ask an expert in the Excel Tech Community or get support in the Answers community.In the Content Control Properties window, you’ll see several options to help you customize the drop-down list. If you want to delete your drop-down list, see Remove a drop-down list. For example, check to see if the cell is wide enough to show your updated entries. If the Source box contains a named range, like Departments, then you need to change the range itself using a desktop version of Excel.Īfter you update a drop-down list, make sure it works the way you want. Then click and drag to select the new range containing the entries. If the list of entries ends up being longer or shorter than the original range, go back to the Settings tab and delete what's in the Source box. In this example, you'd add or remove entries in cells A2 through A5. If the Source box contains a reference to a range of cells (for example, =$A$2:$A$5), click Cancel, and then add or remove entries from those cells. For example: Fruits,Vegetables,Meat,Deli. When you're done, each entry should be separated by a comma, with no spaces. If the Source box contains drop-down entries separated by commas, then type new entries or remove ones you don't need. ![]() On the Settings tab, click in the Source box. Select the cells that have the drop-down list. In Excel for the web, you can only edit a drop-down list where the source data has been entered manually. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |