Forum Discussion
Unwanted default dark cell borders - new sheet or clearing all formatting
Quit Excel.
In File Explorer (assuming you're on Windows), enter
%appdata%\Microsoft\Excel\XLSTART
in the address bar and press Enter. If you see Excel templates named Book.xltx and/or Sheet.xltx in the XLSTART folder, delete them or move them out of this folder.
Start Excel again and see if the problem is gone.
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.
