Phantom borders. Can't delete.
 

Sometimes when I create a Excel spreadsheet and delete cells borders will
remain and I am unable to delete them.

Answer: Phantom borders. Can't delete.
 

I understand that you are facing an issue with phantom borders in Excel that cannot be deleted. This can be frustrating, but there are a few things you can try to resolve the issue.

1. Firstly, try selecting the entire worksheet by clicking on the box at the top left corner of the sheet (above row 1 and to the left of column A). Then, go to the "Home" tab in the ribbon and click on "Clear" in the "Editing" section. From the drop-down menu, select "Clear Formats". This should remove any formatting, including borders, from the selected cells.
   
2. If that doesn't work, you can try using the "Format Cells" option to remove the borders. Select the cells with the phantom borders, right-click and choose "Format Cells". In the "Format Cells" dialog box, go to the "Border" tab and select "None" for all border options. Click "OK" to apply the changes.
   
3. If the above methods don't work, it's possible that the borders are part of a table or a conditional formatting rule. To check for this, go to the "Home" tab and click on "Format as Table" in the "Styles" section. If the "Clear" option is available, click on it to remove any formatting, including borders. If the "Clear" option is grayed out, it means that the borders are part of a conditional formatting rule. To remove the rule, go to the "Home" tab, click on "Conditional Formatting" in the "Styles" section, and select "Clear Rules" "Clear Rules from Entire Sheet".

I hope these steps help you resolve the issue with phantom borders in Excel. Let me know if you need any further assistance!

Phantom borders. Can't delete.
 

HI mtrapani,

Borders are a part of formatting so you can't delete them
like you do with the cells data. You have to highlight the
cell or cells then go to FormatCellsBorder tab and select
no borders. Alternatively you can right click the highlighted cells
and select format cells directly and there is also a selection
of borders buttons on the formatting toolbar usually
just to the left of the the fill and text colour buttons.

HTH
Martin

Phantom borders. Can't delete.
 

I've been doing that and I still have the borders...formatting....I tried
fooling it by telling it to make them "white", tried tool bar,
everything.....my project is perfect ....after hours of work...... if I could
just get rid of the stupid borders!
Help! W

"MartinW" wrote:

HI mtrapani,

Borders are a part of formatting so you can't delete them
like you do with the cells data. You have to highlight the
cell or cells then go to FormatCellsBorder tab and select
no borders. Alternatively you can right click the highlighted cells
and select format cells directly and there is also a selection
of borders buttons on the formatting toolbar usually
just to the left of the the fill and text colour buttons.

HTH
Martin