Want to select datasets quickly in Excel? If you are using a mouse to drag the cursor over hundreds of lines, there is a faster way. 

Click in the first cell you want to select and hold down Ctrl+Shift, then hit either the down arrow to get all the data in the column below, the up arrow to get all the data above, or the left or right arrow to get everything in the row (to the left or right, of course). Combine the directions, and you can get a whole column as well as everything in the rows on the left or right. It'll only select cells with data (even invisible data).