How do you select without dragging?

Toms Tutorials For Excel: Selecting a Large Range Without Scrolling or Dragging.

by 5 Comments

Toms 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. Theres a faster and easier way to select a large range of cells.



Share Button
Toms Tutorials For Excel: Comparing Lists For Identical Match
Toms Tutorials For Excel: Setting Alignments For Date Left and Time Right in a Single Cell

Tags: Analytics, Big Data, Business Intelligence, Cells Ranges Lists, Data Science, Excel Expert, Excel Guru, Keyboard Mouse, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Tips and Tricks, Tom Urtis

Video