+ Reply to Thread
Results 1 to 3 of 3

Put borders at top and bottom of each row, but not sides?

  1. #1
    Registered User
    Join Date
    08-04-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    17

    Question Put borders at top and bottom of each row, but not sides?

    I am using Excel 2010. I have 20 rows and I want to put a border at the top and bottom of each row, as well as a border around the outside of the entire range, but I do not want to have borders on the side of each individual cell.

    How can I do this?

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,672

    Re: Put borders at top and bottom of each row, but not sides?

    Have you tried recording a macro?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    08-03-2012
    Location
    Thomaston,Georgia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Put borders at top and bottom of each row, but not sides?

    Highlight the entire area that you want the outline in , open the border tool at the top of the page on the home tab and scroll down to the full border and click, that will give you your outside border and then highlight all the cells in a row and go back to the border tool and scroll down to the top and bottom border, click, that will give you the lines that you need. Hope that helps

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1