I can select multiple cells if all the cells that I want to select are currently visible on the control. A simple click and drag does the trick.
But, if some of the cells that I want to select are currently off the control and require scrolling to see, I can't select all the cells.
Example. I want to select cells A1 to Z1, but only A1 to G1 are currently visible on the control. I can only select A1:G1, H1 to Z1 cannot be selected along with them because I would have to scroll the control over, and I can't do this while dragging the selection.
In Excel, if you are selecting cells and come to the edge of the control, the control will automatically scroll over until you bring the mouse back into the bounds of the control, or you stop dragging. There doesn't appear to be a "click start cell, then shift and/or control click the end cell" type functionality in the control.
Would it be possible to add some sort of functionality to allow this behavior?