• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 10246
  • Last Modified:

Can't remove cell borders in Excel

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.
1 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 ...

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'
Rory ArchibaldCommented:
Your cells have conditional formatting which is applying the borders. Home tab, Styles group, click Conditional formatting dropdown, then clear rules.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now