Excel sometimes display garbage during F2

by Wemmick   Last Updated May 15, 2019 18:01 PM

I have fairly large Excel sheets under Excel 2016. Lately, I have noticed that sometimes when editing cell (F2), the formula on top left of screen is showing correct like =SUM(xxx:yyy), but on the cell, it is displaying garbage, in fact the garbage always takes the current cell and the next cell to the right of it.

Image of cell during F2

Not all F2s have this, only some. I have tried to copy format from a good cell to these bad cells, and the result is the same, so it is not a formatting issue.

I have tried to scroll the screen up and down so the cell is in a different position on the screen and the same cell have the same effect, so it is not some bad spots on the monitor.

However, related to that, I have 2 screens, and when I move (drag) the Excel from screen 1 to screen 2, I no longer have this effect and the Excel cells are displaying properly. Drag it back to screen 1, and the same cell have the same display effects during F2.

So far, Excel is the only app that has this effect. Question... does this look like a hardware problem (video card?) or a software problem (Excel)? I have not noticed this before, but it may be because the Excel sheet was not as large as before.

Thank you in advance for all your help.



Related Questions


Embed a Vimeo video in Excel

Updated August 22, 2018 16:01 PM

ffmpeg -flags2 +export_mvs ... to in *.txt

Updated November 03, 2015 13:00 PM

How to include video in microsoft word?

Updated December 04, 2015 10:00 AM

Best Tools for Video Conversion

Updated July 03, 2015 17:00 PM