How do I create a template/form I can tab/return to input field?

R

Rose M

I want to develop a template/form I can set text or amount fields and I can
tab to or press return to jump to the input field. The templete will be used
to fill in an existing form (the format is fixed). Thanks for your help. I
am using MS Office 2003 Home version (do not have Access) so I can develop
the form in Word, Excel, Power Point, or Outlook. My OS is Windows XP - Home
 
G

George Nicholson

Sounds like this would be fairly easy in Excel.

1) Every Excel cell has a "Locked" property, and it is set to True/ON by
default. Change each of your data entry cells to Unlocked
(Format>Cells>Protection: Locked = OFF).

2) Turning on Worksheet protection (Tools>Protection>ProtectSheet) is what
applies/activates the locked settings. Make sure "Allow users to Select
Locked Cells" is OFF and "Allow users to Select Locked Cells" is ON.

Once your worksheet is set up this way and protected, the tab key will take
you directly from one unlocked cell to another.

HTH,
 
Top