Posts tagged Locking Excel Cells

Microsoft Excel Tip: How to lock cells and make them un-editable

There are certain times and conditions when you feel the need that other people can only edit or add and modify data from selected cells in your Excel sheet. The rest of the cells in the sheet or workbook must be un-editable. Example of these Excel sheets are survey questionnaires wherein other people can just input their answers but not alter the questions. Others can be a fillable form wherein other people can just enter their personal or other information but the form content and layout are locked for editing…. Read More