How to get to bottom row of data

[MrWonderfull]

If I have over 8000 rows of data in Excel sheet what is the quickest way to get to the bottom of the data so I can select it all? I currently use CTRL+SHIFT+down arrow key but it stops if there is no data in a particular cell. Any way to get around this?

 

[mumps]

Try CRTL+END

 

[xlhelp15]

It works for me, try the below if it fits you.

1. CTRL+PGDWN and keep the pointer in any of the Blankcell -> Press F5 -> SPECIALS -> BLANKS - CLICK OK.
2. Now all the blank cells are selected and press CTRL+A to select All.

 

[tonyyy]

or...

CTRL+SHIFT+END