Delete cells, rows, columns
To delete an unnecessary cell, row, or column:
-
Select cells, rows, or columns you wish to delete,
-
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.