Formatting Issues

How to Fix Excel Cell Text Moving Left While Editing Centered Text

Camila Milosovich Oct 15, 2026 869 views

Question details

The user needs to resolve a display anomaly where text in center-aligned cells temporarily shifts to left alignment while being edited.

How to Fix Excel Cell Text Moving Left While Editing Centered Text

Product: Microsoft Excel
Device & OS: not provided
Scenario: Editing cells that have center alignment and text wrapping applied.
Observed behavior: The text moves to the left alignment during active editing and returns to the center alignment immediately after pressing Enter.

Before you start

Check if this alignment shifting happens in all workbooks or just the current one by quickly opening a new, blank spreadsheet and testing a center-aligned cell.

Solution 1Recommended

Restart Excel and Reopen the Workbook

This formatting anomaly is frequently a temporary display glitch in Excel that can be resolved by a simple application restart.

Excel sometimes experiences temporary rendering errors during prolonged sessions, especially when memory usage is high or after accidental keyboard shortcuts are pressed. Restarting the application clears the temporary state.

Save your work

Press Ctrl + S to save your current workbook.

Close Excel

Click the 'X' in the top right corner to completely exit the Microsoft Excel application.

Reopen the file

Launch Excel again and open your workbook. Double-click the affected cell to see if the text remains centered while editing.

Quick Fix: Many users report that this specific shifting issue disappears permanently after simply reopening the file.

Solution 2

Reset Cell Formatting Settings

If the issue persists, conflicting cell formatting (such as cells formatted as Text rather than General) might be causing the behavior.

Solution 3

Transfer Data to a New Workbook

Corrupted workbook architecture can sometimes cause localized display errors. Moving data to a fresh file helps isolate and eliminate file-specific corruption.

Free Microsoft Office alternative

Experience Glitch-Free Spreadsheet Editing with WPS Office

If Microsoft Excel continues to show frustrating display glitches like text shifting while editing, consider switching to WPS Office. It provides a highly compatible, smooth, and lightweight spreadsheet experience without the high subscription fees.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx file directly.
3. Edit Seamlessly: Enjoy stable cell formatting where center-aligned text stays centered while you type.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Stable and reliable cell formatting without unexpected text shifting during editing.Familiar user interface ensuring a seamless migration with zero learning curve.Lightweight software that loads quickly and consumes fewer system resources.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my text move to the left when I double-click a centered cell?

This is often a temporary display rendering glitch in Excel related to how the application handles cells formatted as 'Text' with 'Wrap Text' enabled during active edit mode. The software temporarily drops the center alignment visually until the edit is committed.

Does the cell format type (General vs. Text) affect text alignment during editing?

Yes. Users frequently report that this specific text-shifting behavior occurs primarily when cells are explicitly formatted as 'Text' rather than 'General'. Changing the number format back to 'General' can often prevent the issue.

Will this display issue affect my printed spreadsheet or PDF export?

No. Because the text returns to the correct center alignment immediately after you press Enter and exit edit mode, the final printed document or exported PDF will correctly display the centered text.

Document & File Issues