Office Settings & Configuration

How to Merge Cells in Excel for Android with WPS Office

Ayan Masood Nov 13, 2026 869 views

Question details

The user wants to merge two columns or a cell range in Excel for Android but cannot find the Merge & Center control available in desktop Excel.

How to Merge Cells in Excel for Android with WPS Office

Product: Microsoft Excel for Android
Device & OS: Android
Scenario: Editing a workbook on an Android phone or tablet and needing to combine adjacent cells without moving the file to a computer.
Observed behavior: The Excel app for Android does not provide the same manual cell-merging controls as desktop Excel, so the user cannot create a true merged cell directly.

Before you start

Before merging, open your workbook and check which cells contain data. True merging keeps only the upper-left value and clears the other selected cells, so move or copy any content you want to preserve.

Solution 1

Use text overflow as a temporary Excel for Android workaround

Use this when the adjacent cells are blank and you only need text to appear across two columns, not a true merged cell.

Select the cell

Open the workbook in Microsoft Excel for Android and tap the cell that contains the longer text.

Make adjacent cells blank

Check the cells immediately to the right. If they contain data, move that data elsewhere so the text can overflow.

Enter long text

Type or paste text that is longer than the column width. Excel for Android will display the overflow into the adjacent blank cell.

Not a real merge: This method changes only the visual appearance. It does not create a real merged cell, and the text remains in the original cell.

Solution 2Recommended

Merge cells directly in WPS Office on Android

Use this when you need actual merged cells on Android without transferring the workbook to a computer.

Merge Excel Cells on Android Without a Computer with WPS Office

With WPS Office Spreadsheets for Android, you can use the mobile Merge & Center tool that the Excel app for Android lacks, so merging two columns or any selected range is done directly on your phone or tablet.

1. Install WPS Office: Open Google Play, search for WPS Office, and tap Install.
2. Open the workbook: Launch WPS Office, tap Files or a cloud location, and open the .xlsx workbook in WPS Spreadsheets.
3. Select the cells: Tap and drag over the two columns or cell range you want to merge.
4. Apply Merge & Center: Tap Home or Edit in the toolbar, then tap Merge & Center and choose the desired merge option.
5. Save the file: Tap Save or Export, choose Excel .xlsx, and store the updated workbook locally or in the cloud.

Adds Merge & Center and Merge Cells to Android spreadsheet editingOpens and saves Microsoft Excel .xlsx files with formatting intactFree, lightweight Office suite with a familiar spreadsheet interfaceNo need to transfer the workbook to a desktop or use an online converter

microsoft office alternative - wps office

Frequently Asked Questions

Does Microsoft Excel for Android have a Merge & Center button?

The Android app does not expose the desktop Merge & Center control in the same way. You can use text overflow as a visual workaround or open the file in WPS Office Spreadsheets to merge cells.

Will merging two columns on Android delete my data?

A true merge keeps only the upper-left cell value and clears the other selected cells. Move or copy data you want to keep before merging.

Can WPS Office open and save Excel files on Android?

Yes. WPS Office opens .xlsx workbooks and can save or export them back to Excel format so you can continue using them in Microsoft Office.

How do I unmerge cells in WPS Office on Android?

Select the merged cell, open the Home or Edit toolbar, and tap Unmerge or the split-cell option to restore the original range.

Office App Problems