Data Entry on Excel Form

Posted by JW on January 10, 2002 6:47 AM

I have created an Excel Form which includes several points of entry, and would like to tab from entry to entry on the form. My book does not indicate how to do this. Can someone help?

Thanks,

Posted by Michael on January 10, 2002 6:57 AM

The only way I know of to be able to tab only to selected cells, is to protect all other cells ( a quick way is to select entire sheet, right click, format cells, Protection and select Locked: Then Unlcok the cells that you want the data entry in (or that need user input or manipulation, and then protect the sheet (Tools, Protection, Protect Sheet). This will allow you to tab between the unlock cells only. Hope this helps.