Merge or unmerge cells

Office Components Spreadsheet

Merge or unmerge cells

  1. Select the cells that you want to merge. Keep in mind that when you merge cells, only data in the upper-left cell of the selected range is retained. Data in all other cells that you merge is deleted.
  2. On the toolbar, click Commands and Options , and then click the Format tab.
  3. Under Cell format, click Merge Cells or Unmerge Cells .