Add, edit, or delete cell contents in Datasheet view
Make changes one cell at a time
You can add, edit, or delete cell contents in edit mode.
- If the cell that you want to edit is not selected, click the cell.
Note If the cell contains a hyperlink, you will navigate to the corresponding Web address.
- Click the cell again to enter edit mode, then make changes to the cell.
Note You can also press F2 to enter edit mode.
- Press TAB or ENTER when done.
Note Click Undo on the task pane toolbar to undo the last change you made to the cell. Press ESC to discard the changes you made to the cell and exit edit mode.
You can bulk edit cells, rows, or columns in one of the following ways:
- By copying and pasting data.
- By dragging the fill handle.