Click the cell whose contents you want to overwrite.
Type the correct data into the cell and press the Enter key.
To delete the data in the selected cell, press the Delete key on your keyboard.
INTRODUCTION
When you overwrite a cell, you replace the cell's contents with new data. Overwriting is handy when you want to correct typing errors or when a cell contains the wrong data. You can also easily erase the contents of a cell by using the Delete key on your keyboard.
TIP
Overwriting Formulas
Be sure you don't overwrite a formula in a cell (unless that is your intention); otherwise, Excel will no longer update the formula. If you accidentally overwrite a formula but you've saved your spreadsheet recently, you can reopen a version of the spreadsheet that was saved before the overwrite operation occurred. Another option is to click the Undo button to undo the overwrite (see the task "Undoing and Redoing Changes" later in this chapter for more information).