A worksheet can also be altered by inserting or by deleting cells. These operations actually alter the locations of cells in a workbook.
Inserting and deleting columns and rows are easy to understand. If you select a group of columns or rows, selecting the Column or Row menu entries in the Insert menu will add the same number of columns to the left of the selected columns or of rows above the selected rows. You can also use the context menu for the insert operation. The context menu can be used to delete the currently selected columns or rows.
Insert operations can result in the loss of data if the last columns or rows currently contain information.
Individual cells or contiguous rectangular blocks of cells can also be inserted and deleted. During this operation, you are asked which way to shift the current cells to allow the insertion or deletion of the selected cells. The movement can be along the rows or along the columns and will result in the relative movement of cells which were previously contiguous. This shift is the fundamental difference between insert and delete operations compared to cut or copy and paste operations.