How to Add a Drop Down Box in Excel 2007 11 Easy Steps
How To Edit Dropdown In Excel. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item. Select the cell that contains the drop.
How to Add a Drop Down Box in Excel 2007 11 Easy Steps
If you set up your list source as an excel table, then all you need to do is add or remove items from the list, and excel will automatically update any associated drop. Select the cell that contains the drop. On the data tab, in the data tools group, click data validation. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item. In the source box, either update the cell references to include the additions.
If you set up your list source as an excel table, then all you need to do is add or remove items from the list, and excel will automatically update any associated drop. If you set up your list source as an excel table, then all you need to do is add or remove items from the list, and excel will automatically update any associated drop. On the data tab, in the data tools group, click data validation. In the source box, either update the cell references to include the additions. Select the cell that contains the drop. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item.
