Is it possible to lock the height and width of a cell

Microsoft Excel allows you to protect one worksheet with password at a time. If you want to protect multiple worksheets with same password at the same time, here recommend the Protect Worksheet utilities of Kutools for Excel. With this feature, you can easily protect multiple or all worksheets in current workbook at a time as the below screenshot shown. Download and try it now! Note: The other languages of the website are Google-translated.

Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. How to lock cell width and height from resizing in Excel? There is no direct way to protect the width and height of cells from being resized other than by protecting the worksheet.

This article will tell you in detail how to lock cell size and height while resizing in Excel. Lock the size and height of cells before resizing by protecting the worksheet. The only way to lock the cell width and height is to password protect the worksheet.

Please follow these instructions. By default, all cells in a worksheet are locked. If you want to keep the cells editable after locking the width and height of the cells, please unlock them in advance.

Select the cells you want to unlock and right click on them. Then click Format Cells from the context menu. Now you need to protect the worksheet to lock the cell sizes.

Then enter a password for your worksheet as shown below. Now the width and height of all cells are locked and cannot be resized by others. Products 75 Special Topics 42 Video Hub Most Active Hubs Microsoft Teams.

Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. FormattingColumns ExcelSheetProtection. FormattingRows ExcelSheetProtection. LockedCells; sheet. Protect "test", options ;. Hi , Sorry for the inconvenience caused. Your code snippet is working fine for resizing the locked cells using Essential XlsIO. Please do let me know if you have any other technical questions or I can be of any other assistance. I will be glad to assist you.

Thank you for your continued interest in Syncfusion Products. Best regards, Sarathi. CB Craig Bart.