Using the tab function

[DDon]

below is a small custom form, is there a way. For example: I would like to be able to start in cell A19 and tab to cell H19. Then have the cursor return to cell A20 when I hit tab again, and so on. All way down to the end of the form.


Excel 2010

	A	B	C	D	E	F	G	H
18	AIR REQUEST	Departure Date	City from:	City to:	Return Date	Preferred Airline	Departure Time	Return Time
19
20	Please indicate choice:	Seating preference:	Window	Best Fare:			Special Meal

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Reservation Request Form​

thank you

 

[Gerald Higgins]

This can be done by unlocking cells in Col A and H, and then turning on worksheet protection.

 

[DDon]

It works perfectly
Thank you