Forum Discussion
Unwanted default dark cell borders - new sheet or clearing all formatting
I have a bunch of Excel files that were created with 97-2003 as an xls. When a new sheet is added all cells have black borders. Also if the cell formatting is cleared, using Editing >> Clear >> Clear...
The XLSTART folder was empty.
I had three others, using different machines, try the workbook and they got the same results.
If I open a new workbook and copy a range of blank cells then paste them in to the older work book I get the black borders.
There must be settings in the workbook that define the default formatting but I have not found where that is.
There are multiple workbooks that have this same issue. All appear to have first been created from 1999-2003. Converting to xlsx does not fix the issue.
This the the new workbook
Here is the result of pasting into the old workbook.
Strange...
You can attach one of the old workbooks that demonstrates the problem if you wish; you can remove all data.