Category: RANGE SELECTION

Select a large data set which has blank rows and columns without using the Shift and arrow keys

{ 2 Comments }

Assume a large data set spanning many rows and columns.  In the data set are entirely blank rows and columns.  As an example, let’s say data is in range A2:G5000, then from A5005:J87634 and then from A87636:F92345.  Furthermore, assume that columns H and I are completely blank.  Data in the filled up cells can be […]

Read More →