Excel 2007 : Sort but borders always remain there. How?

Originally Posted by dilipandey

Hi jp16,

I am not clear on your query, could you post the sample file. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

hmm... i am new here. I do not know how to post sample file. Let says,
Row1 David $20
Row2 Peter $20
Row3 Subtotal $40

I sort in a way that Subtotal goes to Row 1. So it become,

Row1 Subtotal $40 (I underline the border,lets assume underline mean the border being underline)
Row2 Peter $20
Row3 David $20

After that, i sort it back to its original arrangement, i get
Row1 David $20
Row2 Peter $20
Row3 Subtotal $40

How come it wont appear as

Row1 David $20
Row2 Peter $20
Row3 Subtotal $40