Fix Excel Cells That Ignore Text Alignment Settings
Question details
Restore normal text display and alignment in Excel cells after a copy-and-paste operation caused the workbook to freeze.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Working with a workbook after copying and pasting a range of cells.
- Observed behavior
- Some cells display text incorrectly or appear to ignore alignment settings, and the formula bar may show no content.
Close Excel and other Office apps before repairing Office, and make sure you have an internet connection for Online Repair. The repair steps below apply to Windows; menu names may vary by version.
Run an Online Repair of Microsoft Office
Use this option to repair Office when alignment and formula bar problems may be caused by the Excel installation.
In Windows, open Settings > Apps > Installed apps, or Apps & features on older versions.
Find Microsoft 365 or Microsoft Office in the app list, select its menu, and choose Modify. Alternatively, open Control Panel > Programs and Features, select Office, and choose Change.
Select Online Repair, then choose Repair and follow the prompts. If this option is unavailable, follow the repair options shown for your Office installation.
Restart the computer, open Excel, and test the affected workbook. Select a problem cell and check its text, alignment, and formula bar content.

Check the affected workbook and pasted range
Use these checks if Office repair does not resolve the problem or if the issue appears limited to one workbook.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet to continue working with minimal disruption; it does not repair the Microsoft Office installation.

Frequently Asked Questions
Why is the formula bar empty for a cell in a merged range?
A merged range stores its content in the upper-left cell. Select that cell and make sure View > Formula Bar is enabled.
What should I do if Excel alignment works in a new workbook?
Compare the affected cells with other ranges in the original workbook and test an earlier copy. The problem may be specific to the workbook or the pasted range.
Where can I find Online Repair for Office?
On Windows, go to Settings > Apps > Installed apps, find Microsoft 365 or Office, and choose Modify. Select Online Repair if it is available.
Can WPS Office repair my Microsoft Office installation?
No. Use the Office repair options in Windows to repair Microsoft Office. WPS Spreadsheet is an alternative for opening and editing compatible Excel files.




