When you clear cells, Microsoft Graph removes the cell contents (text and values) or formats but leaves the blank cells on the datasheet.
To remove the cells from the datasheet and shift surrounding cells to fill the space, delete the cells instead. How to delete cells, rows, or columns on a datasheet.
Switch to the datasheet.
Select the cell, row, or column you want to clear.
On the Edit menu, point to Clear, and then click All, Contents, or Formats.
Note: If you click a cell and then press DELETE or BACKSPACE, Graph removes the cell contents but does not remove any cell formats.