Related: How To Alphabetize Excel Cells, Columns and Rows How to edit a drop-down list in Excel from a named rangeĪnother way to create an Excel drop-down list is with a named range.
REMOVE DROP DOWN MENU IN EXCEL 2016 UPDATE
You can either extend the cell range to include the new data you entered on your worksheet or reduce the cell range to exclude the data you removed from it.Ĭlick the "OK" button to update your drop-down list and save your changes. In the text box underneath the word "Source," adjust the cell range of your drop-down list. In the pop-up window that opens, click on the "Settings" tab. Select "Data Validation" from the drop-down menu that appears. This typically appears between the "Remove Duplicates" button and the "Consolidate" button. Once you have the data view open, click on the " Data Validation " button at the top of your screen. If you already have this view open, the "Data" tab may appear highlighted or underlined. Open the Excel file you want to edit and then navigate to the specific worksheet that contains the items on your list.Ĭlick on the cells in your list to add and remove items.Ĭlick on the specific cell that houses the drop-down list.Ĭlick the "Data" menu tab in the toolbar at the top of your screen to open the data view. Typically, the cell range originates from a separate table, as in the case of a product drop-down based on an inventory worksheet. One way to create a drop-down list in Excel is to base it on a cell range-a specific collection of cells you've selected. How to edit a drop-down list in Excel from a cell range In this article, we provide step-by-step instructions for editing drop-down lists in Excel for three common scenarios and offer valuable tips to help you optimize the drop-down lists you create. Sometimes, though, it's necessary to update the lists you create, which requires you know how to edit them.
It can not only make a worksheet more dynamic but also improve collaboration and streamline processes among the colleagues with whom you share an Excel file.
A drop-down list is a function in Excel that allows users to select inputs from a predetermined array of options.
0 kommentar(er)
