View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Help with tab in Excel

Under format cell, protection tab, unlock all the cells that you want the
user to fill out. Then, protect the worksheet, allowing users to only select
unprotected cells.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mike Busch" wrote:

I would like to setup a spreadsheet like a form, and have users tab from one
cell to the next, (not in the same row or column) only selecting the next
cell that needs data entered into it, and skipping all in between. Entering
data and then going to the next cell that would need to be populated. I
remember doing this previously, but forgot.