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 ...