Create the list
Once the data has been entered into the table, it can be converted to a list. To do so:
- Select any one
cell in the table.
- Choose List > Create List from the menu to open the Create List dialog box.
- The dialog box shows the range of cells to be included in the list. If the table was created properly, Excel will usually select the correct
- If the range selection is correct, click OK.