How come the AltDown Arrow Shortcut doesn't work when there are blank
cells in the column?

Is there a way to direct the shortcut to look at the entire column
without doing data validation?

Thank you so very much.