How to go End of Huge Data Range?

use CTRL+ Navigation Arrow Key on keyboard
i.e. if you wanna go to the last Non-Blank row in a column press CTRL+Down Arrow key
if your range contains empty cells then use this shortcut SHIFT+CTRL+Arrow key

if you wanna Get the Value of cell in a column you can use this formula
=INDIRECT("A"&COUNTA(A:A))
This formula will work only if there is no Blank Cell in the range.

If they're text values, this formula will return the last text string in column A:

=INDEX(A:A, MATCH("z*",A:A, 1))


If the values are numeric, this will return the last numeric value in column A:

=LOOKUP(99^99, A:A)