Operations with Cells

On working with regular report sheet, various operations with cells are available.

Adding Cells

To add a cell to the range:

Select the Insert > Move Cells Down or Insert > Move Cells Right item in the cell context menu.
Select the Insert > Move Cells Down or Insert > Move Cells Right item in the Cells group on the Home ribbon tab.

After executing one of the operations, a cell is added to the sheet. In this case cells located below or to the right are moved down or to the right. If a cell range is selected, the same number of cells is added as it is in the selected range.

To quickly add a cell above the selected one, select the Insert item in the Cells group on the Home ribbon tab.

Deleting Cells

To delete selected cells from the range:

Select the Insert > Move Cells Up or Insert > Move Cells Left item in the cell context menu.
Select the Insert > Move Cells Up or Insert > Move Cells Left item in the Cells group on the Home ribbon tab.

After executing one of the operations, the cell range is deleted. In this case the cells located below or to the right are moved up or to the left.

To quickly delete a cell above the selected one, select the Insert item in the Cells group on the Home ribbon tab. After executing this command, cells are moved up.

Merging and Unmerging Cells

Selected adjacent cells can be merged into one cell. The merged cell acquires the address of the cell in the top left corner of the merged range.

To merge cells, select a cell range and click the Merge Cells button in the Alignment group of the Home ribbon tab.

To unmerge merged cells, select a merged cell and click the Merge Cells button again:

The merged cell contains data from the first cell in the selected range. After the merge, data of other cells does not disappear, it is only hidden. Thus, after unmerging, data of all cells in the range is restored.