␡
- Editing Data
- Overwriting and Deleting Data
- Undoing and Redoing Changes
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Cutting, Copying, and Pasting Data
- Flipping Rows and Columns
- Moving Data
- Finding Data
- Replacing Data
- Adding and Viewing Cell Comments
- Editing and Deleting Cell Comments
- Inserting Symbols
- Tracking Changes
- Accepting or Rejecting Tracked Changes
- Checking Spelling
This chapter is from the book
This chapter is from the book
This chapter is from the book
This chapter is from the book
Overwriting and Deleting Data
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.
)
)
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.
)