Forum Discussion
Scottisimo
Apr 15, 2023Copper Contributor
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 ...
- Apr 16, 2023
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.
Scottisimo
Apr 16, 2023Copper Contributor
NikolinoDE
Apr 17, 2023Gold Contributor
I'm glad that I could help you a little bit.
I wish you continued success with Excel!
I wish you continued success with Excel!