Tip

[Jonathan Cooper]

To go to the bottom of a bunch of contiguous data, I've alwasy hit the END key, and then the down arrow. Likewise, END right, END up and END left work the same way (you can also hold shift in conjunction with these commans to select data). This morning I stumbled across a way to do this with the mouse. Within a large selection of data, click on a cell. Then move your mouse to the bottom border of the cell (like you were going to drag and drop), then when your cursor looks like a double cross hair, double click. This performs the same function as END down arrow.

 

[Andy B]

Hi

This works with *any* cell border. If you double click the border it will
take you to the extreme edge of the contiguous range.

--
Andy.

To go to the bottom of a bunch of contiguous data, I've alwasy hit the END

key, and then the down arrow. Likewise, END right, END up and END left work
the same way (you can also hold shift in conjunction with these commans to
select data). This morning I stumbled across a way to do this with the
mouse. Within a large selection of data, click on a cell. Then move your
mouse to the bottom border of the cell (like you were going to drag and
drop), then when your cursor looks like a double cross hair, double click.
This performs the same function as END down arrow.