Controling navagation of a form
 

created a form in excel. How do I make it so the client completing the form
can tab through only the cells requiring them to enter information?

As it is now when you hit tab key you move to cells that are background in
the form

Read up on protected cells and forms. When you protect the form, all cells
are protected. You'll need to unprotect the cells you want users to enter
information on. If you have 2003, there is a Protection toolbar that is very
handy to use when you unprotect.

Carole O

"Amanda" wrote:

created a form in excel. How do I make it so the client completing the form
can tab through only the cells requiring them to enter information?

As it is now when you hit tab key you move to cells that are background in
the form