Jumping to the last cell of data

Hi guys,

I have a huge sheet of data, more than 35,000 lines of data and I need to jump to the last cell (without scrolling) quite often but can't remember how. Is it shift, alt page down? Nope. etc. Thanks in advance.

I am pretty sure there is no shortcut...

I have seen people do this to get down to the end:

Formula:

Please Login or Register  to view this content.

I used this to get to the next cell in a column (A in my example) that did have text:

Formula:

Please Login or Register  to view this content.

What? I have to write a VBA to get to the end?

I HAVE IT!!!!!!!!!!

It's literally ctrl and the down arrow!

Ha x

Well, CTRL + DownArrow takes you to the end of the sheet.

I need to jump to the last cell

...I thought you just wanted to go to the end of your list, not the last cell of the sheet. Well, whatever works for you.