Find the Format As Table tool in the main menu.This method is best when you want to format a lot of cells into a dropdown using the same list items. Highlight the range for the drop-down list. If changes are made to the available range (data are added or deleted), they are automatically reflected in the drop-down list.
Create A Drop Down List In Excel Update Your Lists
On the Data tab, in the Data Tools group, click Data Validation :In addition to changing items in your range to update your lists, you can also add new items. Select the cell that needs a drop-down list for data validation (cell B2, in this example). Create a column or a row of the items in the active spreadsheet for the drop-down list. Select the Data tab, click Data Validation and choose Data.To create your own drop-down list for the cell, do the following: 1. Adding Items to Your ListClick on the cell or select the range of cells in which you want to add the drop-down list.
...
0 kommentar(er)
