Ever have to expand a list of numbers in Excel that has a total at the bottom? Ever get annoyed when the line between the list and the total sticks with the list (see below)?
A while back, a client shared a trick with me that keeps the line with the total. The key is to place a TOP border on the SUM line, not a bottom border on the last item in the list. It is quite simple to do.
- After creating the list and adding the sum at the bottom, select the total cell.
- On Font section of the Home ribbon, click the arrow on the borders button.
- Select Top Border from the list.
Now when you add a new row at the end of the list, the line stays with the total:
To make this an even quicker process, see this blog post on customizing the Quick Access Toolbar to add a button for top borders.