Forum Discussion

Happymathematician's avatar
Happymathematician
Copper Contributor
Jun 23, 2019

Changing row height in Excel

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

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        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.

Resources