Search

How to merge cells in Sheets

 

How to merge cells

Merging cells in OfficeSuite Sheets is a useful feature that allows you to combine two or more cells into one larger cell. This can help you create labels, headings, or other formatting options for your spreadsheet. There are different ways to merge cells in Excel, depending on your needs and preferences. Here are some of the most common methods:

 

How to merge cells in Sheets Windows
Merge and Centre: This option merges the selected cells and centres the content of the upper-left cell in the merged cell. To use this option:

1. Select the cells you want to merge.

2. Click the Merge & Centre button on the main tab of the ribbon.

 

 

Merge and unmerge cells in Sheets Android

Merge and unmerge cells:

  1. Select the cells to merge or unmerge.

  2. On the Home tab, tap the Merge/Unmerge icon.

 

Merge and unmerge cells in Sheets iOS

Merge and unmerge cells:

  1. Select the cells to merge or unmerge.

  2. On the Home tab, tap the Merge/Unmerge icon.