View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dom_Ciccone Dom_Ciccone is offline
external usenet poster
 
Posts: 52
Default 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?