Answer

To merge cells in Excel on an iPad, use the Merge option in the Home tab, which combines selected cells into one larger cell.

Steps to Merge Cells in Excel on iPad

1. Select the cells you want to merge by dragging your finger across them.

2. Tap the Home tab in the top toolbar.

3. Tap Merge & Center.

4. Tap one of the merge options:

   • Merge & Center (creates one cell and centers the content).

   • Merge Across (merges each row independently).

   • Merge Cells (merges into one cell without centering).

5. Confirm the merge if Excel displays a warning about keeping only the upper-left cell value.

Important Notes

• Excel keeps the value from the top-left cell and removes content from other cells.

• Excel enables the Merge button after selecting two or more adjacent cells.

• Excel uses the same merge behavior in portrait and landscape mode.

• Excel for iPad does not use right-click options, so the Merge feature always lives in the Home tab ribbon.

Troubleshooting

Why is Merge & Center greyed out?

Merge & Center is unavailable when the worksheet is protected or when the file uses a table format.

How to fix Merge greyed out?

1. Remove the table format:

   • Select anywhere in the table.

   • Tap Table in the top toolbar.

   • Tap Convert to Range.

2. Unprotect the sheet:

   • Tap Review.

   • Tap Unprotect Sheet.

Best Practices

1. Use merged cells sparingly because merged cells limit sorting and filtering.

2. Use Center Across Selection on desktop versions when alignment is needed without merging.

3. Keep merged areas small to avoid layout issues in future formatting.

If you want, I can generate a step-by-step visual guide or explain how to unmerge cells on the iPad.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report