How to Fix Excel Losing Cell Indentation When Changing Vertical Alignment
Question details
Users experience an issue where horizontal cell indentation is unexpectedly removed when modifying the vertical alignment of a cell range.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Changing the vertical alignment (such as setting it to Top) for a large group of previously indented cells, either via the Ribbon or the Format Cells dialog.
- Observed behavior
- The horizontal indentation is lost and resets to default as soon as the vertical alignment is applied.
Before proceeding with updates or workarounds, save your current workbook to ensure no other formatting configurations are accidentally lost during testing.
Install the Latest Office Updates
Since this behavior is recognized as an Excel defect, installing the latest patches from Microsoft is the best way to see if the bug has been resolved.
Microsoft frequently releases bug fixes for known defects in Office applications. Updating your software ensures you have the latest performance patches.
Launch Microsoft Excel. Click on 'File' in the top-left corner, then select 'Account' from the bottom of the left-hand sidebar.
Under the 'Product Information' section, click on the 'Update Options' dropdown box and select 'Update Now'.
Wait for Office to download and apply any pending updates, then restart Excel and check if the vertical alignment still removes cell indentation.

Report the Defect via Microsoft Feedback
If updating does not resolve the problem, reporting the defect directly to Microsoft helps them track and prioritize a fix for future releases.
Workaround: Reapply Indentation After Alignment
If you need an immediate fix while waiting for a patch, you can modify your workflow to apply alignments first and indentations second.
Try WPS Office to Avoid Excel Formatting Bugs
Since the indentation loss is a specific defect within Microsoft Excel, consider trying WPS Office as a lightweight, powerful alternative. WPS Spreadsheet handles complex cell formatting without unexpected conflicts between horizontal and vertical alignment settings, ensuring your data looks exactly as intended.
- 1. Install WPS Office: Download the free WPS Office suite from the official website and run the installer.
- 2. Open Your Excel File: Launch WPS Spreadsheet, click on 'File', then select 'Open' to load your existing workbook without formatting loss.
- 3. Format Seamlessly: Adjust your vertical alignments and horizontal indentations freely without encountering the Excel reset bug.

Frequently Asked Questions
Why does changing vertical alignment affect my horizontal cell indentation?
This is caused by a known defect in certain versions of Microsoft Excel. Logically, vertical and horizontal alignment settings are distinct properties, but a bug within the application causes the horizontal indentation property to reset when the vertical alignment is updated.
Will using the Format Cells dialog prevent the indentation from resetting?
No. Unfortunately, this specific defect can trigger whether you use the quick formatting tools on the Ribbon or apply the changes through the traditional Format Cells dialog box.
Is there a keyboard shortcut to quickly restore indentation in Excel?
Yes. If your indentation is lost after aligning cells, you can select the cells and press Alt + H, then 6 on your keyboard to quickly increase the cell indent without using the mouse.




