Delete cells, rows, columns

To delete an unnecessary cell, row, or column:

  1. Select cells, rows, or columns you wish to delete,

  2. Click the Delete cells  icon situated on the Home tab tab of the top toolbar or select the Delete item from the right-click menu and select the appropriate option:
    if you use the Shift Cells Left option, a cell to the right of the deleted one will be moved to the left;
    if you use the Shift Cells Up option, a cell below the deleted one will be moved up;
    if you use the Entire Row option, a row below the selected one will be moved up;
    if you use the Entire Column option, a column to the right of the deleted one will be moved to the left;

You can also use the Ctrl+Shift+- keyboard shortcut to open the dialog box for deleting cells, select the Shift Cells Left, Shift Cells Up, Entire Row, or Entire Column option and click OK.