Forum Discussion
automatic increase of cell height - how to stop?
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. In the Format Cells dialog box, uncheck the Locked Box on the Protective Equipment click the OK tab button.
Now you need to protect the worksheet to lock the cell sizes. please click review> protection sheet.
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.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
**Source: https://de.extendoffice.com/documents/excel/3817-excel-lock-cell-height-width.html