Excel Performance Problems

Fix Excel Cells That Ignore Text Alignment Settings

Ayan MasoodAyan Masood Nov 20, 2026 869 views

Question details

Restore normal text display and alignment in Excel cells after a copy-and-paste operation caused the workbook to freeze.

Fix Excel Cells That Ignore Text Alignment Settings
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.
Before you start

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.

Solution 1Recommended

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.

1
Open installed apps

In Windows, open Settings > Apps > Installed apps, or Apps & features on older versions.

2
Find Microsoft Office

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.

3
Run Online Repair

Select Online Repair, then choose Repair and follow the prompts. If this option is unavailable, follow the repair options shown for your Office installation.

4
Restart and test Excel

Restart the computer, open Excel, and test the affected workbook. Select a problem cell and check its text, alignment, and formula bar content.

Run an Online Repair of Microsoft Office
Free Microsoft Office alternative

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.

Adjust cell alignment using familiar spreadsheet controlsOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar interface that makes migration easierWork with a free, lightweight office suite
microsoft office alternative - wps office

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.