Merge or unmerge cells

Office Web Components

Merge or unmerge cells

  1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
  2. 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.
  3. On the toolbar, click Commands and Options Button image, and then click the Format tab.
  4. Under Cell format, click Merge Cells Button image or Unmerge Cells Button image.