A ahhhmed Member Nov 22, 2011 #1 Hi, How do we lock cells so that they cannot be edited, and at the same time leave some cells open for editting?
Hi, How do we lock cells so that they cannot be edited, and at the same time leave some cells open for editting?
Luke M Excel Ninja Staff member Nov 22, 2011 #2 Under Format cell, protection tab, there should be an option to "lock cell". Uncheck this box on any cell you want the user to still be able to edit, then protect then sheet.
Under Format cell, protection tab, there should be an option to "lock cell". Uncheck this box on any cell you want the user to still be able to edit, then protect then sheet.
