Not as easy as Control-Shift-Down but better than 'mousing to the middle'. Once this is set up it is easy to repeat for other columns just leave the reorganize pane open. When done, uncheck the 'show rows that match the following' box in the reorganize pane. Back on the table, you can now click on the top cell, quickly scroll to the bottom, and shift-click the bottom cell. Now your table will show only the rows with non-blank cells in that column. In the second part of the pane that pops up is 'show rows that match the following'. I am assuming you are selecting all, or at least from somewhere near the top all the way to the bottom.Ĭlick 'reorganize' on the menu bar. And, I don't know if you are trying to select all of the non-blank cells in the column or going down to row 10000 and selecting from there to the bottom. I'm not sure what you are going to do after you select those cells so this idea might not work for you. If there were, Excel's Control-Shift-Down wouldn't work either.
I am assuming there are no gaps in the data in a column.
