Formatting Issues

How to Fix Excel Losing Cell Indentation When Changing Vertical Alignment

Tauseeq MagsiTauseeq Magsi Oct 28, 2026 870 views

Question details

Users experience an issue where horizontal cell indentation is unexpectedly removed when modifying the vertical alignment of a cell range.

Excel Loses Cell Indentation When Changing Vertical Alignment
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 you start

Before proceeding with updates or workarounds, save your current workbook to ensure no other formatting configurations are accidentally lost during testing.

Solution 1Recommended

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.

1
Open Account Settings

Launch Microsoft Excel. Click on 'File' in the top-left corner, then select 'Account' from the bottom of the left-hand sidebar.

2
Check for Updates

Under the 'Product Information' section, click on the 'Update Options' dropdown box and select 'Update Now'.

3
Restart Excel

Wait for Office to download and apply any pending updates, then restart Excel and check if the vertical alignment still removes cell indentation.

Install the Latest Office Updates
Update Availability: If your Office software is managed by your organization's IT department, you may need to contact them to authorize and deploy the latest updates.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download the free WPS Office suite from the official website and run the installer.
  2. 2. Open Your Excel File: Launch WPS Spreadsheet, click on 'File', then select 'Open' to load your existing workbook without formatting loss.
  3. 3. Format Seamlessly: Adjust your vertical alignments and horizontal indentations freely without encountering the Excel reset bug.
Highly compatible with Microsoft Excel file formats (.xlsx, .xls, .csv).Stable formatting engine that maintains cell indentation and alignment independently.Free to use with a familiar, user-friendly interface that requires zero learning curve.Lightweight application that uses fewer system resources and loads files quickly.
QA img-9

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.