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

In Excel 2007, select the Insert tab on the ribbon, ... 'Ungroup' and 'Send to front/back' options on the Drawing toolbar in earlier versions of Excel. 4. Constraining objects.