Delete a row or column in Datasheet view

1. Click the row header of the row that you want to delete.

   Note  To delete multiple rows, click the first row header and then drag to the last row. Or, select the first row, then hold down SHIFT and select the last row.

2. Right-click the selection and click Delete Rows.

1. Right-click the column header of the column that you want to delete, and then click Edit/Delete Column.
2. On the Change Column page, click Delete.

Notes

• You can delete only one column at a time. If cells in multiple columns are selected, the column containing the active cell will be taken as the selected column.
• If a column is read-only, you cannot delete it. Also, you cannot delete some columns in lists of a certain type, because these columns are required for the list to function properly.