Modify a column in Datasheet view

Microsoft Datasheet View

You can change a column’s name, description, and data type, or settings related to its data type.

  1. Right-click a cell in the column that you want to modify, and then click Edit/Delete Column.
  2. On the Change Column page, make the changes, and click OK.

Notes

  • You can modify 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 modify it.