Misaligned cells when scrolling in excel 2016

Question

Whenever I open a sheet in Excel and I scroll in the sheet, the rows gets misaligned and I keep having to click in the Header to get the sheet back to normal. I have Excel 2016 and run under Windows 10. How can I stop this from happening.

Answer 1

Hi,

Thanks for your response.

Let's open a new Excel sheet, click File > open and navigate to the location where the issue causing documents are located, select them and click OK and check how it works.

If issue persist, let us repair Office from the Control Panel and check.

https://support.office.com/en-in/article/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

Hope it helps. Try the suggestions and let us know the result at your earliest convenience.

Thank you.

Answer 2

I opened Excel 2016 in safe mode and my excel files do the same thing, when I scroll, the cells (rows) overlap one another and are misaligned and I have to click in the header to be able to view some rows. I disabled the add-ins yet it does the same thing, no change. I remarked that most the files were created in my former Excel 2010.

Answer 3

Had to choose Repair option from Control Panel and ran the repair. I verified my documents and it repaired all documents except one document so I am satisfied. Thanks for the help, much appreciated.

Answer 4

Hi, 

Thank you for posting your query in Microsoft Office Community.

A quick question before we proceed.

Is the issue specific to Excel or Excel file? What happens with other Office applications?

Let’s restart the computer and then open the Excel in Safe Mode again and check if it helps.

To do that, press the ‘Windows + R’ key on the keyboard.

In the Run open box type in ‘Excel /Safe’ and hit ok.

Note: There is a space between Excel and /.

If application safe mode works, try disabling the add-ins associated with Office applications and check.

http://office.microsoft.com/en-in/access-help/view-manage-and-install-add-ins-in-office-programs-HA010354315.aspx

Hope it helps. Try the suggestions and let us know the result at your earliest convenience.

Thank you.