Excel Trick: Quickly Select Large Data Sets π
Learn a fast method to select large data ranges in Excel without clicking and dragging, avoiding unwanted cells efficiently.

WheeliePete
371.5K views β’ Aug 31, 2020

About this video
A really fast way to select huge runs of data in columns or rows quickly without picking up unwanted cells. Way faster than click-n-drag selecting and more targeted than selecting the whole spreadsheet's column or row.
***UPDATE - Additional Info*** If your data range selection with this trick does hit a blank cell and stops, you can just tap the direction arrow a couple times to get past it, then take your fingers off the keys and hit the three button combo again to resume selection to the bottom of the data or the next blank cell.
***UPDATE - Additional Info*** If your data range selection with this trick does hit a blank cell and stops, you can just tap the direction arrow a couple times to get past it, then take your fingers off the keys and hit the three button combo again to resume selection to the bottom of the data or the next blank cell.
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
371.5K
Likes
2.9K
Duration
3:26
Published
Aug 31, 2020
User Reviews
4.3
(74) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.