Sep 20 2017 11:12 AM
Hi, excel has these weird border issues today that I am unable to find a solution to. I type a number in a cell, it highlights, but when i click away, a balck highlight/border stays there. The border actually stays on the entire row. Hard to explain, not sure if anyone knows the solution. All workbooks, tried re-starting. Photo attached, I apologize for the rotation.
Sep 20 2017 11:31 AM
Hi Gabriella,
I don't know the answer, just to clarify - did i understood you correctly what if you open Excel with new workbook (not existing one), and add the number into any cell, this border appears?
Sep 20 2017 11:43 AM
Thank you for your reply. Yes. New or existing, all workbooks. It disappears once I click away, for example to a different tab. Reappears every time I add something to a cell.
Sep 20 2017 01:42 PM
I see, strange. Googled a bit, some people reports the same e.g. https://stackoverflow.com/questions/46308435/excel-automatically-adds-borders-when-changing-cell-val...
No conditional formatting, no VBA code. Have no idea what that could be. What i usually do in such situations
- check if the same is in safe mode (Win+R and "excel /safe"). If not when disable add-ins one by one if they affect;
- clean PC (CCleaner or like);
- repair Office
Other steps depends on situation. By the way, could you please attach any of your files where such effect appeared?
Sep 21 2017 04:29 AM
Thanks for looking into it. I'm about the wipe my laptop and start over!!
This is not something you can just learn to work with :)
Thanks again !
Sep 21 2017 04:44 AM
Quite risky, i'd play with other options first. Anyway, good luck!
Sep 21 2017 04:49 AM
Thank you for the response. I'm attaching one of the files. I sent it to my coworker and he had no problem with it.
Sep 21 2017 05:55 AM
Hi Ewa,
I also found nothing suspicious in file itself and in it XML structure. Works normally.
Don't think that affect something, removed some properties - please check attached.
Sep 21 2017 06:50 AM
Thank you for your help Sergei. I still have the same problem with the files that you send back. It's strange that the borders seem random in thickness and how they appear. When I copy the spreadsheet to Word they disappear. It's really annoying but the Excel still works. I appreciate your help. Please let me know if you think about any other suggestions.
Sep 21 2017 07:32 AM
Ewa, please install this fix