You are viewing: How to create the drop down list in excel At HTTLEN: Share Good Articles
After you create your dropdown list, make sure it works the way you want it to. For example, you might want to check if you change the column width and row height to display all your posts.
If the list of your dropdown list entries is in 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 decide you want to change the options in your dropdown list, see Add or remove items from a dropdown list.
To delete a dropdown list, see Delete a dropdown list.
.