Custom Excel Entry Form

Is there a way to create a custom form in Excel that looks like something in
MS Word where you can enter any kind of data then automatically go to the
next data entry cell? I know you can create an entry form but I believe you
need to have all the column names adjacent to each other in the same row or
in one column sequencially. I'm thinking of the flexibility to enter data
like in A2 then after pressing the Enter key going to another cell not
adjacent to Cell A2. Maybe I just need to figure out how to do it in MS Word
but I wanted to do it in Excel if it is possible.

Regards,
rw