![]() Now you need to protect the worksheet to lock the cell sizes. In the Format Cells dialog box, uncheck the Locked box on the Protection tab, then click the OK button. Select and right click the cells you need to unlock, then click Format Cells from the right-clicking menu. If you want to keep cells editable after locking the cells’ width and height, please unlock them in advance.ġ. ![]() Please do as follows.īy default, all cells in a worksheet are locked. ![]() The only way for you to lock the cell width and height is to protect the worksheet with password. Lock cell width and height from resizing with protecting the worksheet This article will show you in details of how to lock cell width and height from resizing in Excel. How to lock cell width and height from resizing in Excel?įor locking cell width and height from resizing, there is no direct way except protecting the worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |