automatic increase of cell height - how to stop?

%3CLINGO-SUB%20id%3D%22lingo-sub-2132668%22%20slang%3D%22en-US%22%3Eautomatic%20increase%20of%20cell%20height%20-%20how%20to%20stop%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2132668%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20with%20the%20following%20problem%3A%20If%20I%20enter%20even%20one%20letter%20in%20a%20cell%2C%20Excel%20automatically%20increases%20the%20height%20of%20the%20cell%20and%20thus%20of%20the%20entire%20row.%20I%20marked%20all%20the%20rows%20and%20defined%20the%20cell%20height%20(I%20used%20the%20different%20ways%20which%20are%20also%20possible%20for%20this)%20and%20I%20also%20removed%20all%20the%20formations%20from%20the%20Excel%20list%2C%20but%20Excel%20still%20turns%20all%20cells%20into%20cells%20of%20almost%20700%20pixels%20as%20soon%20as%20I%20click%20in%20a%20cell%20and%20enter%20a%20single%20letter.%20As%20I%20have%20never%20formatted%20a%20cell%20in%20such%20a%20size%20I%20don't%20know%20where%20this%20came%20from.%3CBR%20%2F%3EUnfortunately%20I%20have%20not%20yet%20found%20a%20useful%20tip%20on%20google%2C%20but%20the%20need%20to%20adapt%20every%20row%20after%20typing%20just%20on%20letter%20is%20very%20annoying%20-%20I%20have%20also%20tried%20the%20automatic%20formatting%20settings%20under%20Options%20to%20see%20whether%20this%20could%20help.%20I%20would%20be%20very%20grateful%20for%20any%20help%20and%20thank%20you%20very%20much%20in%20advance!%3C%2FP%3E%3CP%3EAll%20the%20best%2C%3C%2FP%3E%3CP%3ENicole%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2132668%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2133275%22%20slang%3D%22de-DE%22%3ESubject%3A%20automatic%20increase%20of%20cell%20height%20-%20how%20to%20stop%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2133275%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F966008%22%20target%3D%22_blank%22%3E%40Nicolemedwiss4you%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHow%20to%20lock%20cell%20width%20and%20height%20from%20resizing%20in%20Excel%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThere%20is%20no%20direct%20way%20to%20protect%20the%20width%20and%20height%20of%20cells%20from%20being%20resized%20other%20than%20by%20protecting%20the%20worksheet.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThis%20article%20will%20tell%20you%20in%20detail%20how%20to%20lock%20cell%20size%20and%20height%20while%20resizing%20in%20Excel.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ELock%20the%20size%20and%20height%20of%20cells%20before%20resizing%20by%20protecting%20the%20worksheet%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20way%20to%20lock%20the%20cell%20width%20and%20height%20is%20to%20password%20protect%20the%20worksheet.%20Please%20follow%20these%20instructions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20default%2C%20all%20cells%20in%20a%20worksheet%20are%20locked.%20If%20you%20want%20to%20keep%20the%20cells%20editable%20after%20locking%20the%20width%20and%20height%20of%20the%20cells%2C%20please%20unlock%20them%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20the%20cells%20you%20want%20to%20unlock%20and%20right%20click%20on%20them.%20Then%20click%20Format%20Cells%20from%20the%20context%20menu.%20In%20the%20Format%20Cells%20dialog%20box%2C%20uncheck%20the%20Locked%20Box%20on%20the%20Protective%20Equipment%20click%20the%20OK%20tab%20button.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Zellen_sperren-1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254829iD188E7B507A6E4FD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Zellen_sperren-1.png%22%20alt%3D%22Zellen_sperren-1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENow%20you%20need%20to%20protect%20the%20worksheet%20to%20lock%20the%20cell%20sizes.%20please%20click%20review%26gt%3B%20protection%20sheet.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Zellen_sperren-2.png%22%20style%3D%22width%3A%20934px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254830iE4502DD8DF1C10DF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Zellen_sperren-2.png%22%20alt%3D%22Zellen_sperren-2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThen%20enter%20a%20password%20for%20your%20worksheet%20as%20shown%20below.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Zellen_sperren-3.png%22%20style%3D%22width%3A%20699px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254831i11E62AEA7D752459%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Zellen_sperren-3.png%22%20alt%3D%22Zellen_sperren-3.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENow%20the%20width%20and%20height%20of%20all%20cells%20are%20locked%20and%20cannot%20be%20resized%20by%20others.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E**Source%3A%20%3CA%20href%3D%22https%3A%2F%2Fde.extendoffice.com%2Fdocuments%2Fexcel%2F3817-excel-lock-cell-height-width.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fde.extendoffice.com%2Fdocuments%2Fexcel%2F3817-excel-lock-cell-height-width.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, 

I need help with the following problem: If I enter even one letter in a cell, Excel automatically increases the height of the cell and thus of the entire row. I marked all the rows and defined the cell height (I used the different ways which are also possible for this) and I also removed all the formations from the Excel list, but Excel still turns all cells into cells of almost 700 pixels as soon as I click in a cell and enter a single letter. As I have never formatted a cell in such a size I don't know where this came from.
Unfortunately I have not yet found a useful tip on google, but the need to adapt every row after typing just on letter is very annoying - I have also tried the automatic formatting settings under Options to see whether this could help. I would be very grateful for any help and thank you very much in advance!

All the best,

Nicole

1 Reply

@Nicolemedwiss4you 

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.

 

Zellen_sperren-1.png

Now you need to protect the worksheet to lock the cell sizes. please click review> protection sheet.

 

Zellen_sperren-2.png

Then enter a password for your worksheet as shown below.

Zellen_sperren-3.png

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