When you use the click-Shift-click combination, the first cell you select remains active. To activate a different cell in the same row of the selection, press Tab and Shift+Tab. To move up and down ...

One way to get around this issue is to convert the Excel table to a range by selecting any cell in the table, and clicking ...

The Excel Options dialog box will pop up click OK.. On the worksheet, type one of the data from your custom list into a cell. Drag the cell down with the fill handle. You will see all the data you ...