Fix Repeated or Misaligned Column Data in Excel
Question details
Troubleshoot Excel columns that display repeated or misaligned cell data.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is viewing a workbook in Excel and sees partial repeats or offset cells in columns.
- Observed behavior
- Moving the cursor can shift the display problem to other cells, and pressing Ctrl+Home may clear it temporarily.
Test another workbook to see whether the display issue is limited to one file. The troubleshooting steps below use Windows menus and paths.
Test Excel in Safe Mode and disable add-ins
Use Safe Mode to check whether an add-in or startup component is contributing to the display issue.
Close Excel, press Windows+R, enter excel /safe, and select OK. Open the affected workbook and check whether the columns display correctly.
If the issue does not occur in Safe Mode, restart Excel normally and go to File > Options > Add-ins. Review the active add-ins listed there.
At the bottom of the Add-ins window, select COM Add-ins or Excel Add-ins in the Manage list and click Go. Clear one add-in checkbox, click OK, and restart Excel to test; repeat as needed.

Temporarily move Excel startup files
Test whether files in the user's Excel settings and startup folder contribute to the issue.
Repair Microsoft Office
Repair the Office installation if the display issue persists after testing add-ins and startup files.
View Excel Workbooks in WPS Spreadsheets
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files in WPS Spreadsheets to continue working while you troubleshoot Excel.

Frequently Asked Questions
Why does Ctrl+Home only clear the display problem temporarily?
Ctrl+Home moves the selection to the beginning of the worksheet and may refresh the visible area, but it does not identify or remove the underlying cause. Test Excel in Safe Mode and check add-ins if the problem returns.
Do inactive Excel add-ins need to be disabled?
Inactive add-ins are generally not loaded, so check active add-ins first under File > Options > Add-ins. Use the Manage list and Go button to disable active COM or Excel add-ins one at a time.
How can I tell whether the problem affects just one workbook?
Open a different workbook in Excel and check whether its columns also appear repeated or offset. Then open the affected workbook in Safe Mode using Windows+R and excel /safe.
What is the difference between Quick Repair and Online Repair?
Quick Repair is the first repair option to try from the Office Modify menu. If it does not resolve the issue, return to the same menu and run Online Repair, which requires an internet connection.




