Equivalent to clicking the Delete command on the Edit menu. Removes the selected cells from the worksheet and shifts other cells to close up the space.
Syntax
EDIT.DELETE(shift_num)
EDIT.DELETE?(shift_num)
Shift_num is a number from 1 to 4 specifying whether to shift cells left or up after deleting the current selection or else to delete the entire row or column.
| Shift_num | Result |
| 1 | Shifts cells left |
| 2 | Shifts cells up |
| 3 | Deletes entire row |
| 4 | Deletes entire column |
If shift_num is omitted and if one cell or a horizontal range is selected, EDIT.DELETE shifts cells up.
If shift_num is omitted and a vertical range is selected, EDIT.DELETE shifts cells left.
Related Function
CLEAR Clears specified information from the selected cells or chart
Return to index