When you protect a worksheet in Excel, also locks the row height and column width so that no one can change it.īut with sheet protection, all the cells are also locked and you cannot make any changes to it (i.e, you can not get into the edit mode or enter formulas). How to Lock Row Height and Column Width in Excel (Easy Trick) Disabling the Lock Property for all Cells.