User Tools

Site Tools


excelmerge

Merging Cells with no data

  • Hightlight Cells
  • Format Cells
  • Alignment Tab - Choose Merger Cells

'Merging Content onto a new cell =CONCATENATE(A14,B14)

Split a Merged Cell

http://office.microsoft.com/en-us/excel/HP052510211033.aspx#SplitMergedCells

Split merged cells

You can split only cells that were previously merged.

Select the merged cell.

When you select a merged cell, the Merge and Center button also appears selected (selected: A toolbar button always has a border around it when it's selected, even when the pointer is not resting on the button.) on the Formatting toolbar.

To unmerge cells, click Merge and Center .

Note When the merged cell is split, the contents of the merged cell will appear in the upper-left cell of the range of split cells.

excelmerge.txt · Last modified: 2017/09/28 16:30 by zeppo