Clear cells, rows, or columns on a datasheet

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.

  1. Switch to the datasheet.

    How?

  2. Select the cell, row, or column you want to clear.

    How?

  3. 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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×