• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Editing Worksheets > Overwriting and Deleting Data

Overwriting and Deleting Data

Click the cell whose contents you want to overwrite, making it the active cell.

Type the correct data into the cell and press the Enter key.

Click the cell whose contents you want to delete, making it the active cell.

Press the Delete key to delete the data in a cell.

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. Erasing a cell is useful when you change your mind about the contents after you enter the data in the cell. You might find that a piece of data you initially typed into a cell is incorrect and needs to be changed.


TIP

Overwriting formulas

Be careful not to overwrite formulas if that is not what you intended. If you overwrite a formula with a constant value, Excel no longer updates the formula. If you accidentally overwrite a formula but you've saved your spreadsheet recently, you can reopen the spreadsheet to a version saved before you overwrote the formula.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint