• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to select

G

GN0001

Member
I have 60000 rows, when I click ctrl+shit down arrow, it select to cell 52000, because after that a few cells are empty, and I hit another down arrow, it selects to last cell of the spreadsheet, what should I do to select the rest of cells in column till cell 60000.


your help is greatly appreciated.

Guity
 
Depending on your data what you've done is correct and you need to do it several times if there are blank cells


You can also try Ctrl Shift End which will select down to the lower right extent of your data and then shift across if required with Ctrl Shift Left or Shift Left
 
You must log in or register to reply here.
Back
Top