[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Can't remove cell borders in Excel

Posted on 2012-08-22
Medium Priority
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 14

Accepted Solution

frankhelk earned 2000 total points
ID: 38320990
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

ID: 38320997

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
ID: 38320999
Your cells have conditional formatting which is applying the borders. Home tab, Styles group, click Conditional formatting dropdown, then clear rules.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

834 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