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.
How?
How?
Note If you click a cell and then press DELETE or BACKSPACE, Graph removes the cell contents but does not remove any cell formats.