![]() In the Format cells dialog box that opens up, click on the ‘Protection’ tabīy doing this we have ensured that even if we protect the entire worksheet the cells would still remain editable.In the Number group, click on the dialog box launcher icon (the small tilted arrow icon at the bottom right of the group).Select all the cells in the worksheet by clicking on the gray triangle at the top-left part of the worksheet.Protect the worksheet so that row height and column width for each cell is lockedĭisabling the Lock Property for all Cellsīelow are the steps to disable the lock property for all the cells, after which we can lock the row height and the column width:.Disable the ‘Locked’ property for all the cells.While we want to lock the column width and the row height, we don’t want to lock the cells completely.Īnd thankfully, you can do that in Excel.įor this to work, you need to do two things: 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.How to Lock Row Height and Column Width in Excel (Easy Trick).
0 Comments
Leave a Reply. |