Formatting Issues

Fix Excel Cell Text Moving to the Bottom-Right After Double-Clicking

Nimra MalikNimra Malik Nov 18, 2026 868 views

Question details

The user wants to understand why cell text appears to move to the bottom-right after a double-click and correct its alignment.

Fix Excel Cell Text Moving to the Bottom-Right After Double-Clicking
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user double-clicks a worksheet cell to edit its contents.
Observed behavior
The cell content appears to shift toward the bottom-right after double-clicking.
Before you start

Select an affected cell and check whether the apparent shift happens only while editing or remains after you press Enter. Double-clicking enters edit mode, which can temporarily change how the cell contents are displayed.

Solution 1Recommended

Adjust Excel cell alignment and check related formatting

Use this solution when text remains misaligned after editing or appears to shift because of worksheet formatting.

1
Select the affected cells

Click the affected cell or drag to select the range, then open the Home tab and find the Alignment group.

2
Set the alignment

In Home > Alignment, choose Top Align or Middle Align for vertical alignment and Align Left for horizontal alignment. Use Decrease Indent until any unwanted indentation is removed.

3
Check detailed settings

Right-click the selection, choose Format Cells, and open the Alignment tab. Set Horizontal to General or Left, Vertical to Top or Center, and Indent to 0 where available.

4
Review wrapping and merged cells

On the Home tab, check Wrap Text and Merge & Center. Turn off wrapping or unmerge cells only if those settings are not needed, then double-click the cell and press Enter to test it.

5
Inspect the number format

If spacing still looks unusual, right-click the cell and choose Format Cells > Number. Check whether a Custom format adds spacing; change it only if appropriate for the cell's value.

Adjust Excel cell alignment and check related formatting
Changing formats can affect display: Changing a number format can alter how dates, numbers, or leading zeros appear. Unmerging cells changes the worksheet layout.
Adjust spreadsheet alignment

Correct cell alignment in WPS Spreadsheet

Open the workbook in WPS Spreadsheet and adjust the affected cells' alignment, indentation, wrapping, or merge settings.

  1. 1. Open the workbook: Open WPS Spreadsheet, select Open, and choose the Excel workbook.
  2. 2. Select the cells: Click the affected cell or select the range, then go to the Home tab.
  3. 3. Adjust alignment: Use the Home tab's alignment controls to select left and top or center alignment and decrease any unwanted indent.
  4. 4. Review formatting: Right-click the selection and choose Format Cells to inspect alignment and number format settings. Check the Home tab's Wrap Text and merge controls if the layout still looks wrong.
Adjust cell alignment and indentation from the worksheetOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceGet started with WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Why does the cell look different when I double-click it?

Double-clicking enters Excel's cell edit mode, which can temporarily change the display. Press Enter to finish editing and check whether the alignment still looks wrong.

How do I remove an indent from an Excel cell?

Select the cell and use Home > Alignment > Decrease Indent. You can also right-click the cell, choose Format Cells > Alignment, and set Indent to 0 where available.

Can merged cells or wrapping affect text position?

Yes. Select the cell and check Home > Wrap Text and Merge & Center. Change these settings only if they are not needed for the worksheet layout.

Can a custom number format add unwanted spacing?

Yes. Right-click the cell and choose Format Cells > Number > Custom to inspect its format. Changing the format may also change how dates, numbers, or leading zeros appear.