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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies