Forum Discussion
Daniel Bartlett
Nov 26, 2017Copper Contributor
Excel random black bars error
Hey everyone, I've been having this random error where a bunch of black bars appear randomly on my excel workbook. I've tried uninstalling and reinstalling to no avail. I think its a display or compatibility issue but I'm not exactly sure.
3 Replies
Sort By
- Tanya DentonSteel ContributorFound this post which seems similar to yours https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_365hp/getting-really-odd-black-vertical-lines-in-excel/34f5e377-dbd6-4c8c-868e-fef88b12b545 Solution is: 1) Click File, Options and then Advanced 2) Scroll down to Display and click the check box to Disable Hardware Graphics Acceleration Maybe that will work.
- Daniel BartlettCopper Contributor
TANYA FOR THE WIN! Thank you so much. I wish I could give you a cookie!
- Ghazanfar KhanCopper ContributorTake a print (hard copy) of this and if the lines appear on the print page as well then it certainly is a problem with your computer settings. Too many cells are visible which means you have zoomed out too much and MS excel doesn't show accurate data when you zoom out too much so zoom in a little and try to see these bars again. Most probably these bars will disappear because they aren't present, it's just zoom scaling issue of MS Excel which is harmless.
Peace.