How do I sort cell formats with data being sorted?

[HNCJr]

I created an Excel 2003 (11.6355.6360 SP1) worksheet (6 columns by 233 rows)
that contains some cells in which text wraps to two or more lines. All cells
are formatted as "Wrap Text."

When I sort the data, the formats (specifically the "wrapped text cells")
don't sort with the data.

Is there a way to make the formats sort with the data?

 

[Jim Cone]

Formats applied with Conditional Formatting will not sort.
Also, borders will not sort. Otherwise, formats should sort with the data.
I don't have XL 2003, so I can't determine if MS has "improved" things again.
Did the sort work before today?
Does it work on another XL version. Does it work on another computer?
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"HNCJr" <[email protected]>
wrote in message
I created an Excel 2003 (11.6355.6360 SP1) worksheet (6 columns by 233 rows)
that contains some cells in which text wraps to two or more lines. All cells
are formatted as "Wrap Text."
When I sort the data, the formats (specifically the "wrapped text cells")
don't sort with the data.
Is there a way to make the formats sort with the data?

 

[HNCJr]

Jim,

Thanks for your response. It's maddening that Excel can't sort the formats
with the cells. It means that a report can look really good in one order, and
terrible in all others.

I think I figured out what my problem was with regard to the wrapped text
cells not sorting. I had previously set all row heights to a specific value,
and then had to manually resize the rows when text wrapped. It didn't occur
to me that by setting the row height, I was disabling Excel's abililty to
automatically resize the rows when text wrapped. After I unspecified the row
height, it worked the way I expected. It's obvious now that I see what was
going on, but I didn't see it before. I'm used to working in Word, where rows
can be set to a minimum height - that's what's missing from Excel (well, one
thing of many that are missing...).

Thanks,

- Nelson Crooks