Can't remove cell borders in Excel

Posted on 2012-08-22
Last Modified: 2012-08-22
I received an Excel file that contains data in cells that have a black border.  Trying to change or remove the borders has no effect.  The spreadsheet is not protected or shared, nor is their any VBA code.  The behavior occurs even when i copy the cells into a new spreadsheet.  Please see attached example.
Question by:PsimonTech
    LVL 13

    Accepted Solution

    I've taken a look at that.

    The borders are realized with "Conditional formatting", which seems to be broken anyhow.

    I just have Excel 2003, so I can't exactly tell you the way to the conditional formatting dialog for your somewhat later version of Excel. But Iwould recommend this site to look at.It should give you the right clues ...
    LVL 13

    Expert Comment


    The borders are there because of conditional formatting.

    Select the area you want to clear borders
    Go to 'Home' tab
    Click Conditional Formatting - select 'Clear rules' then select 'Clear rules from selected cells'
    LVL 85

    Expert Comment

    by:Rory Archibald
    Your cells have conditional formatting which is applying the borders. Home tab, Styles group, click Conditional formatting dropdown, then clear rules.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now