How to Edit Cells in Excel

How to Edit Cell Data in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

How to Edit Cells in Excel

Cell data is the text or the numbers within a cell. It can be text you type in, numbers, or formulas. When you start creating a spreadsheet, one of the first steps is to enter data in the cells.

Enter Cell Data

  1. Click the blank cell where you want to add data.

    You know the cell is active because a border appears around it.

  2. Type your data into the cell.

    Notice that the text you type also appears in the Formula bar.

  3. Press Enter or click the Enter button.
    Enter Cell Data

Replace Cell Data

In addition to adding data in a blank cell, you can also type data into a cell that is already populated.

  1. Select the cell that contains the data you want to replace.

    The old information is automatically selected.

  2. Enter the new information.
  3. Press Enter or click the Enter button.
    Replace Cell Data

The new information is added in the old data’s place.

Delete Cell Data

If you want to remove the data all together, you can delete it.

  1. Select the cell that contains that data you want to delete.
  2. Press the Delete key on your keyboard.
    Delete Cell Data

The data is deleted from the selected cell.

Edit Cell Data

In addition to replacing and deleting data, you can also make edits.

  1. Click the cell you want to edit.
  2. Click in the formula bar.
  3. Make your changes.
  4. Press Enter or click the Enter button.
    Edit Cell Data

The cell is updated with the new text.