I know you can configure Excel to either go to the next cell to the right or the next cell down when you hit the tab/enter key but can you tell it what cell specifically to go to next after you hit the enter/tab key. I have made up a form using only the basics in Excel and in areas of the form you have to use the arrow keys in order to get to the next entry cell which may be as much as 5 key strokes in different directions. Would be easier to use something in excel to do this for you. Would a macro do this?

Just as an example I would want with only one key stroke when I depress the enter/tab key for the active cell to go from C1 to C6

Thanks
Mark