Tom’s Tutorials For Excel: Selecting a Large Range Without Scrolling or Dragging.
Here is a handy shortcut tip when you need to select a large range. In the example, I selected a small range of B2:H5 so the pictures can fit onto this web page for demonstration purposes.
But what if you need to select a large range from B2 to, say, HM62000. It would be a burdensome task to scroll down all those rows, and across all those columns, while dragging your mouse from B2:HM62000. There’s a faster and easier way to select a large range of cells.