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%3CLINGO-SUB%20id%3D%22lingo-sub-1650315%22%20slang%3D%22en-US%22%3EThe%20question%20was%20CELL%20height%2C%20not%20Row%20Height.%20how%20do%20I%20set%20the%20height%20of%20an%20individual%20cell%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1650315%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1650697%22%20slang%3D%22en-US%22%3ERe%3A%20The%20question%20was%20CELL%20height%2C%20not%20Row%20Height.%20how%20do%20I%20set%20the%20height%20of%20an%20individual%20cell%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1650697%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F787678%22%20target%3D%22_blank%22%3E%40DFuller19371234%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20title%20of%20the%20question%20is%20%3CSTRONG%3EChanging%20row%20height%20in%20Excel%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3EAnyway%2C%20that's%20a%20grid%2C%20you%20can't%20change%20the%20height%20or%20width%20of%20individual%20cell%2C%20only%20of%20entire%20row%20or%20column.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20merge%20cells%2C%20however%20that%20is%20not%20recommended%20practice.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

 

3 Replies

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). 

@DFuller19371234 

The title of the question is Changing row height in Excel.

Anyway, that's a grid, you can't change the height or width of individual cell, only of entire row or column. 

You may merge cells, however that is not recommended practice.