I have a lot of data I'm entering into a sheet like this:

A B C D
1 2 3
2 4
2
3
1
3

Simple. But some columns end up with little or nothing in them, some get a
hundred+ entries. When I enter something in "A", then need to enter the next
value into "B", I have to move to the right column, scroll up or jump to
bottom, then enter. Back to A? Same thing. Lots of scrolling up and down.

Is there some way to set up a row at the top that's the "entry" row so each
entry is in the same place vertically and the numbers pop down, as if I hit
insert before each entry? Then I would only have to move left and right and
the values would cascade down from that row. Kind of like doing a split to
keep the column titles at the top, this would keep the next empty cell of
each column at the top.

Does that make any sense? Any ideas?