You’re not stuck with the first data you enter into a cell. In fact, you can change the value completely, delete it, or update it to reflect a supplier’s new business name or a customer’s new address. You also are not stuck with only one way to edit the data; you can edit the data either in the Formula Bar or directly in the cell.
Edit Cell Contents in the Formula Bar
Click the cell you want to edit.
Select the text you want to edit in the Formula Bar.
Type the new text and press Enter.
Tip
If you’re editing a cell and decide you don’t want to keep your edits, press the Esc key to return the cell to its previous state.
Edit Cell Contents Directly in the Cell
Double-click the cell you want to edit.
Select the text you want to edit.
Type the new text and press Enter.
Tip
In previous versions of Excel, you needed to select a check box to enable editing directly in a cell. You don’t have to check a box in Excel 2007—you can just double-click and edit to your heart’s content.