Row heights when sorting

  • Thread starter Thread starter M Davila
  • Start date Start date
M

M Davila

It doesn't take the row height when i do a sort -
therefore it either cuts off some of my information or the
row it way too tall for the information...any fixes?
 
After sorting, highlight all sorted rows (not cells), and then double
click on one of the lines above or below the row numbers on the left of
the sheet. This should solve your problem
 
If row heights are set to autofit then they will be adjusted after the data
is sorted. But any row whose height is manually set will stay as it is. So
your best course is to reset autofit. To do that select the rows in
question (or the entire worksheet by pressing Ctrl-a) and select Format,
Row, Autofit.
 
-----Original Message-----
It doesn't take the row height when i do a sort -
therefore it either cuts off some of my information or the
row it way too tall for the information...any fixes?
.
Not sure what response you've had on this however, you
Click to expand...
could possible try in one or both of two ways:
1. Highlight all lines with data and double click on the
row height control to automatically adjust row heights to
fit the test.
2. Apply 'shrink to fit' in the cell options, alignment
area for the whole list.
Good luck. Wayne.
 
Back
Top