Javatpoint Logo

91-9990449935

 0120-4256464

How to delete data, rows and columns in Excel

How to Delete Data

Select the data you want to delete, right click on it then select delete option from the menu. You can also delete it by pressing Delete key on the keyboard. See the image:

How to delete data in Excel

How to Delete a Row

Select the row by a left click on the row number then right click and select the Delete option. If you want to delete more rows drag the mouse downward to select more rows. See the image:

How to delete row in Excel

How to Delete a Column

Select the column by a left click on the column header then right click and select Delete option. To delete more columns drag the mouse horizontally left or right to select more columns. See the image:

How to delete column in Excel