Next, click on the "Name Manager" button at the top of your screen. If you already have this view open, the "Formulas" tab may appear highlighted or underlined. Select the "Formulas" menu tab in the toolbar at the top of your screen to open the formulas view. To edit a drop-down list based on a named range, follow these steps: The list source is similar to that of a regular cell range, except the cells you're referencing have a commonly assigned designation, such as "Price" for a range of price-related data. 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. 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)
