Copy Formula Down to Specified Row

[PhotoGump]

Im trying to copy a cell formula down from say, O2 down to O161886 where my data actually ends. But when I attempt the common Ctrl+End, it actually goes to the end of nowhere nowhere (about the millionth row) instead of where physical data ends.

What Shortcut Keys or methods are used in dealing with this phenomenon?

 

[Michael M]

If the formula is in O2 and the data is continuous in col N....
Highlight cell O2 and then double click on the little black square at the bottom right of the cell

 

[PhotoGump]

I knew it had to be too simple! Thanks!