ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   row height does not move with row when sorting (https://www.excelbanter.com/excel-discussion-misc-queries/260569-row-height-does-not-move-row-when-sorting.html)

dennis

row height does not move with row when sorting
 
When sorting a spreadsheet with rows of varying row heights, the row height
setting does not move with the respective row resulting in not all data in
cells being displayed or with large empty areas in others.

Gord Dibben

row height does not move with row when sorting
 
That is correct.

The rows don't move...........the data moves.

Format the cells to wrap text and rows to autofit.

You should see a difference.


Gord Dibben MS Excel MVP


On Fri, 2 Apr 2010 12:01:03 -0700, Dennis
wrote:

When sorting a spreadsheet with rows of varying row heights, the row height
setting does not move with the respective row resulting in not all data in
cells being displayed or with large empty areas in others.




All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com