Tom’s Tutorials For Excel: Selecting a Large Range Without Scrolling or Dragging.

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.



Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,
5 comments on “Tom’s Tutorials For Excel: Selecting a Large Range Without Scrolling or Dragging.
  1. Charmaine says:

    Brilliant

  2. Wytek says:

    I would like to select a range that is 100 by 100 cells, starting with the left top corner anywhere on the sheet. How can I do this?

  3. asdasd says:

    Maybe I am doing something wrong, but in my case, I would need a way to first find out the cell address of the bottom-right corner.

    Is there a trick to doing this? Because for very far-away cells, I would be using my mouse pointer on the scroll-bar grip-rectangle to scroll very quickly and easily overshooting. So I need to solve this problem.

  4. Clive says:

    Asdasd
    CTRL + END (hold control and press end) will take you to the last used cell of a sheet.
    CTRL + * extends out until it hits a blank row and blank column, and highlights the whole region

Leave a Reply

Your email address will not be published.

*