Home

Changing row height in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-715705%22%20slang%3D%22en-US%22%3EChanging%20row%20height%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715705%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%3C%2FP%3E%3CP%3EI'm%20new%20to%20excel%20and%20would%20appreciate%20some%20help.%3C%2FP%3E%3CP%3EI%20have%20set%20up%20a%20table%20and%20when%20I%20enter%20text%20into%20one%20cell%20I%20want%20the%20cell%20to%20have%20fixed%20width%20but%20to%20increase%20in%20height%20as%20the%20text%20goes%20down%20to%20the%20next%20line.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Office%20365%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-715705%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-715826%22%20slang%3D%22en-US%22%3ERe%3A%20Changing%20row%20height%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715826%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365233%22%20target%3D%22_blank%22%3E%40Happymathematician%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20rows%20will%20auto-adjust%20the%20height%20if%20the%20cell%20with%20the%20text%20is%20set%20to%20Wrap%20Text.%20To%20do%20that%2C%20select%20the%20cells%20or%20the%20whole%20table%20column.%20Then%2C%20on%20the%20Home%20ribbon%20click%20the%20%22Wrap%20Text%22%20command.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENote%20that%20the%20row%20height%20will%20not%20auto-adjust%20for%20merged%20cells%20(one%20more%20reason%20to%20avoid%20merged%20cells).%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Happymathematician
Occasional Visitor

Hi guys

I'm new to excel and would appreciate some help.

I have set up a table and when I enter text into one cell I want the cell to have fixed width but to increase in height as the text goes down to the next line.

 

I am using Office 365

 

Thanks

 

1 Reply

Hello @Happymathematician ,

 

Excel rows will auto-adjust the height if the cell with the text is set to Wrap Text. To do that, select the cells or the whole table column. Then, on the Home ribbon click the "Wrap Text" command.

 

Note that the row height will not auto-adjust for merged cells (one more reason to avoid merged cells).