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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |