Everyone makes data entry errors. You need to correct errors quickly so you can move on with completing your work. In Excel, here are some ways to do that.

If the error just occurred:

1. [ESC] key on the keyboard. If you are still typing and have not hit [Enter] yet, press [ESC]. This cancels what you’ve begun to type in to a cell, but have not confirmed yet. (If you have already hit [Enter], see instructions below).
2. Click the Red X on the formula bar. This is the same thing as pressing [ESC]. The red X will not be available if you have already entered the data. This is only if you are still typing in the cell.
3. UNDO: If your error is recent, you can Undo. To undo:
Keyboard method – CTRL Z; (This one works in almost all programs)
Toolbar method – Undo Button (Left-facing blue arrow)
Menu method = EDIT > UNDO

If the error has already been entered, you have 2 options:

1. Click on the cell and simply re-type the correct entry. You do not have to press delete first, though that would work as well. The correction can be re-typed in the cell or on the formula bar.
2. Delete: Highlight the cells to delete data from, press [DELETE] on your keyboard.

Remember – UNDO is your best friend!