Hi, my data consist of companies name, the room their workers is staying and the name of the workers. The list is over 3000+ long. We need to charge them Admin fee, laundry fee etc. I use the Subtotal function so that i could c the subtotal of all the admin fee etc, however, i need to underline the subtotal. I sort in a way that all the subtotal will appear on top. For example, Row 1-230. Den i do the underlining. However, how come when I sort it back to its original, the underline border remain at row 1-230? It wont move together with the subtotal.

I use Filter instead, and this time it works. I am just curious how come when I sort, the border wont go together with the cell. It stay in the same row. Anyone can advice?