How do I select cells in a column from an active cell to the last non blank cell in the same column when there are multiple blank cells in the range and CTR+Shift + Arrow Down doesn’t work because it stops at every blank cell on its way? (I don’t need to select the whole column- I need it to stop at the last cell that has data). In my case I have data in column A in range (A2:A25000) with about 10 thousand blank cells in between, I need to quickly select (A2: A25000)
Thanks a lot!
Bookmarks