Web press ctrl+g > special, then data validation > all or same, and repeat the steps above.
How to add or remove items from a drop down list in excel. How you do that depends on how the list was created. Select the data tools group from the data tab. Add code to remove and restore protection before the following.
Go to the formulas tab, then. Select the range of cells, click copy to another location,. You can also select multiple cells.
Web on the data tab, in the sort & filter group, click advanced. Web @sebastianszyroki if you want to show/hide columns based on selection of option from choice column, you can use conditional formulas in sharepoint. Web on the ribbon, click data > data validation.
Select the cells containing your drop. The “ignore blank” check box is checked by default. Add a new item to your list, or delete the one you don't want.
This means that the user can select the cell and then deselect. In the dialog, set allow to list. This will be the location of the drop down list items.
In the source box, add new list. Web excel will take you to the location of the named range.