To achieve this, right click on the sheet tab of Sheet2 and click on Hide. Note: this makes your drop-down list case sensitive. For example, if a user types yes, an error alert will be displayed.
You can add or remove items from a drop-down list in Excel without opening the 'Data Validation' dialog box and changing the range reference.
This saves time. Note: Excel automatically changed the range reference from Sheet2! You can check this by opening the 'Data Validation' dialog box. To remove an item from a drop-down list, at step 2, click Delete, select "Shift cells up" and click OK. You can also use a formula that updates your drop-down list automatically when you add an item to the end of the list.
I added a new field, but it is not appearing on the drop-down menu. How do I fix this? Click on cell A1. Not Helpful 18 Helpful Place a checkmark next to the field labeled "Ignore blank" if you want users to have the option of selecting zero items from the drop-down list when they use the spreadsheet. Not Helpful 12 Helpful 4. Simply add to the table that corresponds to your drop-down list and it's automatically inserted.
Not Helpful 6 Helpful 5. How do I delete the tab where the list items are, since this will be a form used for work? Not Helpful 7 Helpful 1. How do I protect the column so the user can only select from the drop-down menu? This enables the user to only select from the drop-down list. Not Helpful 1 Helpful 3. Include your email address to get a message when this question is answered. By using this service, some information may be shared with YouTube. After you finish creating your drop-down list, open the drop-down list to make sure all the items you entered display properly.
In some cases, you may need to widen the cell in order to display all your items fully. Helpful 2 Not Helpful 1. When typing the list of items for your drop-down list, type them in the order in which you want them to appear in the drop-down menu. For example, you can type your entries in alphabetical order to make it easier for users to find certain items or values.
Helpful 0 Not Helpful 0. Submit a Tip All tip submissions are carefully reviewed before being published. You will not be able to access the "Data Validation" menu if your worksheet is protected or shared.
In this case, make sure to remove the protection or unshare the document , and then try to access the Data Validation menu again. You Might Also Like How to. How to. About This Article. Co-authored by:. Co-authors: Updated: March 27, Categories: Featured Articles Microsoft Excel. Article Summary X 1. Deutsch: Eine Dropdown Liste in Excel erstellen.
Nederlands: Een vervolgkeuzelijst maken in Excel. Thanks to all authors for creating a page that has been read 1,, times. The step-by-step screen shots were very helpful, and I got it in one go. More reader stories Hide reader stories. Is this article up to date? Cookies make wikiHow better. By continuing to use our site, you agree to our cookie policy. Dolly Dhiman Jan 19, Anonymous May 17, Thank you. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy.
Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Popular Course in this category. Course Price View Course. Free Excel Course. Login details for this Free course will be emailed to you. Email ID. Contact No.
0コメント