How to edit data in a cell in Excel 2007?

To edit data in a cell, click to select the cell that need to edit. You can edit data directly from the cell or from the Formula bar.

Edit data directly from the cell:
Double click the cell. The mouse cursor changes to Text Select. Use the following techniques to edit the data:

• Use the arrow keys or mouse to move around the data
• If the data is single line, press the HOME key to move to the beginning of the data. Press the END key to move to the end of the data.
• If the data is multiline, press the CTRL + HOME keys to move to the beginning of the data. Press the CTRL + END keys to move to the end of the data.
• To select the data, press and hold the SHIFT key and press the arrow keys. To select data from the current location to the beginning or end, press SHIFT + HOME or SHIFT + END. For multiline data press CTRL + SHIFT + HOME or CTRL + SHIFT + END.
• To delete selected data, press the DELETE key.
• To delete the data that is on the left, press BACKSPACE key.
• To delete the data that is on the right, press DELETE key.
• To insert data, place the mouse cursor at the exact location and enter the data. For example in AC, to insert data B between A and C, place the mouse cursor between A and C and type B.

Edit data from the Formula bar
When you click a cell, the data is present in the Formula bar as well. Edit the contents as per your needs. One more use is that, if a cell has a formula and you need to edit the formula then the formula is present in the Formula bar. Edit the formula and press ENTER key.

Edit cells that has multiple lines of text with line breaks in Excel 2007

For information regarding entering multiple lines of text in a cell, click the following link:
Enter multiple lines of text in a cell
Once you had entered multiple lines of text in a cell and decide to edit some text then you can do it by performing the following steps:
1. Click the cell that has multiple lines of text with line breaks.
2. Click the Formula Bar to edit the first line of text.

3. For editing other lines of text, click the down button in the Spin button to move to one line of text at a time. Edit the text and press the Enter key.