Ease of entry on an form designed in excel
Select all of the cells that you want the user to be able to enter data into,
right click and choose Format Cells. On the Protection tab, uncheck the
"Locked" option. Click OK.
Now go to Tools--Protection--Protect Sheet. On the dialog box that
appears uncheck "Select Locked Cells". Click OK. Pressing tab will now move
you between the open cells.
--
Kevin Ciccone
"Chork" wrote:
Is there a way to enable users who once they enter data into a cell, simply
hit the tab key and move to the next cell requiring data entry?
|