Office Performance Issues

Fix Repeated or Misaligned Column Data in Excel

Jason MillerJason Miller Nov 14, 2026 868 views

Question details

Troubleshoot Excel columns that display repeated or misaligned cell data.

Fix Repeated or Misaligned Column Data in Excel
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.
Before you start

Test another workbook to see whether the display issue is limited to one file. The troubleshooting steps below use Windows menus and paths.

Solution 1Recommended

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.

1
Open Excel in Safe Mode

Close Excel, press Windows+R, enter excel /safe, and select OK. Open the affected workbook and check whether the columns display correctly.

2
Review active add-ins

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.

3
Disable add-ins individually

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.

Test Excel in Safe Mode and disable add-ins
Inactive add-ins: Inactive add-ins are generally not loaded, so start by testing active add-ins. If the issue also occurs in Safe Mode, continue with the startup-file and repair checks.
Free Microsoft Office alternative

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.

View and edit spreadsheet columns in WPS SpreadsheetsCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface makes the transition easierFree, lightweight office suite
microsoft office alternative - wps office

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.