How prepare Excel file to sort when rows are unequal height

  • Thread starter resevmirejudsha
  • Start date
R

resevmirejudsha

I would like to be able to sort Excel files by various columns, but am unble
to do so because my rows are not all of equal length
 
B

Beth Melton

This group is dedicated to Word issue and there are Excel specific
newsgroups for Excel related questions. But, since you're here,

Are you sure the message you are encountered is 'rows' and not merged
cells? If that's the case then you'll need to remove the merged cells
if you want to sort. Select the cell range you are using for sorting
and either click the "Merge and Center" command on the Formatting
toolbar or go to Format/Cells and on the Alignment tab clear the tick
in the "Merge cells" option. Note if it doesn't appear empty (if it's
shaded) then click the check box until it is an empty check box.

If you have any additional questions then they should be posted in one
of the Excel newsgroups. :)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Top