Forum Discussion
Incorrect row height after sort
Hello! When I do a sort in an Excel workbook, it does not readjust the row height, so that the rows are either small, in which case I can't see all of the text, or too large, in which case there is empty space in the row. Anyone have the answer?
I'm on Windows 11.
If the row heights in your Excel workbook are not adjusting correctly after sorting, you can try manually adjusting the row heights to fit the contents of the cells.
Here’s how:
- Select the rows that you want to adjust. You can do this by clicking and dragging over the row headers (the numbered boxes to the left of the rows).
- Right-click on one of the selected row headers and choose “Row Height” from the context menu.
- In the “Row Height” dialog box, enter a value for the row height or leave it blank to use the default height. Click “OK” to apply the new row height.
Alternatively, you can use the “AutoFit Row Height” feature to automatically adjust the row heights based on the contents of the cells.
Here’s how:
- Select the rows that you want to adjust.
- On the “Home” tab of the ribbon, click on “Format” in the “Cells” group.
- From the “Format” drop-down menu, choose “AutoFit Row Height”. This will automatically adjust the row heights to fit the contents of the cells.
I hope one of these solutions works for you!
Here is a link with information on how you can get a quick and precise solution proposal.
5 Replies
If the row heights in your Excel workbook are not adjusting correctly after sorting, you can try manually adjusting the row heights to fit the contents of the cells.
Here’s how:
- Select the rows that you want to adjust. You can do this by clicking and dragging over the row headers (the numbered boxes to the left of the rows).
- Right-click on one of the selected row headers and choose “Row Height” from the context menu.
- In the “Row Height” dialog box, enter a value for the row height or leave it blank to use the default height. Click “OK” to apply the new row height.
Alternatively, you can use the “AutoFit Row Height” feature to automatically adjust the row heights based on the contents of the cells.
Here’s how:
- Select the rows that you want to adjust.
- On the “Home” tab of the ribbon, click on “Format” in the “Cells” group.
- From the “Format” drop-down menu, choose “AutoFit Row Height”. This will automatically adjust the row heights to fit the contents of the cells.
I hope one of these solutions works for you!
Here is a link with information on how you can get a quick and precise solution proposal.
NikolinoDE Is there a way, outside having a macro that triggers when a sheet is sorted, to have the AutoFit Row Height adjust to the new sort, without having to manually re-trigger it?
I have attached an example in the attached file.
I hope it helps you.
Otherwise, I always recommend starting a new conversation and describing your problem in great detail. Because not every suggested solution is suitable for everyone. It always depends on the Excel version, operating system, storage medium, file extension, etc.
- I'm glad that I could help you a little bit.
I wish you continued success with Excel!
