sorting cell borders

[Russ]

When sorting a spreadsheet in MS Excel XP, is there a way to sort cell borders with the original rows and columns they were applied to? Thanks!

 

[Mark W.]

No. Sorting shuffles the contents of a cell... not the cells themselves.

 

[Juan Pablo González]

Altough Mark IS right... maybe, depends on your spreadsheet, you could use Conditional Formatting to "tie" the formatting with the values.

 

[Nimrod]

Though before sorting you could hide a column with the row values in it .. which could later then be used to refer to the orginal order.

 

[Russ]

Thanks for the help everyone!