1. Home
  2. Computing & Technology
  3. Spreadsheets

Entering Data in Excel

By , About.com Guide

8 of 8

Editing Cells in Excel

Editing data in a cell using the Excel formula bar

Editing data in a cell using the Excel formula bar

© Ted French

Change Complete Cell Contents

  • Click on the cell, type over the existing entry, and press the ENTER key on the keyboard.
Change Part of the Cell Contents
  • Method 1
    • Click on the cell to make it the active cell.
    • Click on the data in the formula bar.
    • Delete the part to be changed and type in the new data.
    • Press the ENTER key.

  • Method 2
    • Double click on the cell.
    • Edit the part of the cell you want to change.
    • Press the ENTER key.

In the example above, the highlighted numbers 5 and 6 in the formula bar can be removed by hitting the DELETE key on the keyboard and replaced with different numbers.

Return to Index page

Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel 101
  5. Editing Cells in Excel Spreadsheets - Changing the Data in an Excel Cell

©2009 About.com, a part of The New York Times Company.

All rights reserved.