Use the Delete dialog box to delete a row, column, or cell.
Shift Cells Up
Enable to shift the remaining cells upward to fill the space left by the
deleted cells.
Shift Cells Left
Enable to shift the remaining cells to the left to fill the space left by the
deleted cells.
Row
Enable to delete a row.
Column
Enable to delete a column.