auto row height when using sort functio

Question

hi All, new here I'm trying to get auto row height to work when text is in the sort are of a sort function&nbsp;=SORT(J2:Q26, 1, ) the formula does the trick but the cell height will not expand no matter what i do its like it doesn't&nbsp;see any text in the cell so defaults to standard height. any help appreciated

nikolinode · Answer

ditchfia&nbsp;If you can’t see all the data in a cell, changing the row height or column width can help:Change column width or row heightExcel for the web&nbsp;&nbsp;Hope I could help you with these information / links.&nbsp;NikolinoDE

ditchfia · Answer

NikolinoDE&nbsp;&nbsp;yes its already very wide. i just cant figure how to get the cell height to auto adjust to suit the relevant text

nikolinode · Answer

ditchfia&nbsp;Start -&gt; Format -&gt; Adjust column width automatically or&nbsp;Adjust row height automatically&nbsp;It is probably not what you are looking for. But what exactly you are looking for is not understandable to me from the text. Unfortunately, the translation doesn't help me either. Therefore, I recommend that you insert a file (without sensitive data) and explain exactly what you want to do with an example. &nbsp;Thank you for your understanding and patienceNikolinoDE&nbsp;&nbsp;

ditchfia · Answer

NikolinoDE&nbsp;&nbsp;a test spread sheet is attached, so text is entered into text entry tab, its then processed with if functions to bring only rows with the word open in the last cell, then i use the sort function to collate all cells with text in at the top and this is where i cant get the row height to auto adjust.&nbsp;Thanks

nikolinode · Answer

ditchfia&nbsp;Is there some way that the row height can be calculated automatically ???For merged cells: NOBut there is only one way possible with VBAYou cannot create, run, or edit VBA in Excel for the web.&nbsp;How To Make Excel Cells Expand To Fit Text AutomaticallyThis Link shows how to make an excel cell expand it’s width and height to fit the input text width or height automatically.&nbsp;Would you like to automatically adjust the column width in your Excel sheet to the content?Quick guide: Automatically adjust column width in ExcelSelect the column that you want to adjust the width.You can also select multiple columns at once.In the "Start" tab, click on "Format" in the "Cells" area.A menu opens.Now select the item "Automatically adjust column width" under "Cell size".The marked columns now adjust their width.&nbsp;Excel for the webAll Users can view and lightly edit Office files using Office for the web.To see what commands are supported by Excel for the web, click on the upper link.&nbsp;In the inserted file an example with VBA, but you work with Excle for web...&nbsp;Thank you for your understanding and patience&nbsp;I wish you a lot of success and fun with excel.&nbsp;NikolinoDE

Forum Discussion

auto row height when using sort functio

5 Replies

Resources