+ Reply to Thread
Results 1 to 2 of 2

How to keep Thick border when filtering

  1. #1
    Forum Contributor
    Join Date
    03-30-2007
    Location
    London, UK
    MS-Off Ver
    Microsoft Office 2007
    Posts
    317

    How to keep Thick border when filtering

    Hi Guys,

    First of all Happy New to you all I hope you had a good one.

    Now, I have a problem when I AutoFilter. I have a spreadsheet which has a thick border from rows 5 to 100. I used the really thick border that you get from the Draw Borders drop down list the very last border line that is available.

    What my problem is when I filter to one of the criteria that I choose, only some of the columns keep the thick border and some columns have the normal thin border.

    Is this because I drew the borders manually with the Draw Borders tool?

    How can I make it so that when I filter the bottom line will always show a thick border?

    Thanks in advance for any help given.
    Last edited by VBA Noob; 01-02-2008 at 11:03 AM.
    Best Regards.

    Michael
    -----------------------------------
    Windows Vista, Microsoft Office 2007

  2. #2
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    I just made a test spreadsheet and put on thick borders with format, cells, borders, and they stayed ok with autofilter.

+ 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