Excel: Use top border for underline


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)?

SS-2011.03.17-08.06.05

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.

  1. After creating the list and adding the sum at the bottom, select the total cell.
  2. On Font section of the Home ribbon, click the arrow on the borders button.
    SS-2011.03.17-08.11.15 
  3. Select Top Border from the list.
    SS-2011.03.17-08.12.13

Now when you add a new row at the end of the list, the line stays with the total:

SS-2011.03.17-08.14.01

To make this an even quicker process, see this blog post on customizing the Quick Access Toolbar to add a button for top borders.

Advertisements
  1. #1 by Minnesota homes on April 17, 2013 - 4:05 pm

    Heya this is kind of of off topic but I was wanting to know if blogs
    use WYSIWYG editors or if you have to manually code with
    HTML. I’m starting a blog soon but have no coding expertise so I wanted to get guidance from someone with experience. Any help would be enormously appreciated!

  2. #2 by ramadan 2013 prayer schedule on July 28, 2013 - 2:56 am

    Simply want to say your article is as surprising. The clearness in your post is simply nice and i could assume you are an
    expert on this subject. Fine with your permission allow me to grab your RSS feed to keep up to date with
    forthcoming post. Thanks a million and please keep up the enjoyable work.

  3. #3 by Kristin on April 15, 2014 - 2:28 am

    Definitely imagine that that you stated. Your favorite justification appeared to be at
    the net the easiest factor to be mindful of. I say to you, I certainly get irked even as other folks consider worries that they just don’t
    realize about. You controlled to hit the nail upon the highest and defined out
    the entire thing without having side-effects , other folks could take a signal.

    Will probably be again to get more. Thank you

  4. #4 by Abbie on May 22, 2014 - 4:13 pm

    It protects your Nexus S from dust, smudges and scratches
    while providing a superb grip. For better or worse, though, it may be
    “one” of HTC’s last. Do you have other unique tips to
    solve the above problem.

  5. #5 by Major Demayo on July 14, 2017 - 2:04 am

    It has been really one of the best blogs i have checked out. It was actually very informative.Looking ahead for more blogs of this in near coming future

  1. mini
  2. seo|vps|hosting|dedicated|server
  3. frederick mover
  4. Limestone mining processing equipment
  5. no more panic, no more panic attacks, no more anxiety attacks
  6. Gamer Gaia is your game review and preview site for Xbox 360, PS3, Wii, PC, 3DS, PSP & iPhone games with expert game reviews, game news, game previews, game trailers, game cheat codes, game strategy guides and game walkthroughs
  7. tts
  8. GMAC Short Sale San Diego
  9. Police Car Aucrions
  10. canvas artwork

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: