

Click on the second delete option called “delete sheet rows.”

Click on the delete cells so that we will get the below delete option as shown in the below screenshot. First, select the row you exactly need to delete, as shown in the below figure.So in this, we need to delete the cells which are shown in the below steps.Īssume that we need to delete the row that has been highlighted in green color. Sometimes it is required to delete unwanted rows and columns in the data. Example #1 – Delete CellsĬonsider the below example, which has sales data. We will see all these options one by one. Delete Sheet: Which is used to delete the entire sheet.Delete Sheet Column: Which is used to delete the selected column.Delete Sheet Rows: Which is used to delete the selected rows.Delete cells: Which are used to delete the selected cells.

Once you click on the delete cells, we will get the following options:
