View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How do I allow data entry to one column only?

Lock all the cells you want to protect and then protect the worksheet itself.
--
Gary''s Student - gsnu200855


"Carmen" wrote:

I've created an order sheet that needs to have all data locked except one
column and one cell.

How do I lock the sheet and allow data entry to the areas I want accessible
without having to create a password for users?