EXCEL TRICK – Select large data quickly in columns & rows WITHOUT click & drag or unwanted cells




About this tutorial:

Video duration: 00:03:26
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.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

1 thought on “EXCEL TRICK – Select large data quickly in columns & rows WITHOUT click & drag or unwanted cells

    tjousk

    (September 16, 2020 - 6:01 pm)

    If you come to a gap in your data, keep holding shift, let go of end, arrow key past the gap, then end+arrow again.
    The only key you have to hold is shift. You can press and release end then press an arrow.
    There's also shift+ctrl+end to select all rows and columns from the current cell to the end of the data.

Leave a Reply

Your email address will not be published. Required fields are marked *