BUY EXCEL BOOKS ONLINE: 1. VBA & Macros      2. VBA for Modelers      3. Excel 2013 VBA and Macros     
4. Excel VBA for Dummies      5. Excel with VBA & .NET      6. Mastering VBA      7. Excel 2013 Programming

How to edit or modify a cell in Excel 2007?


1. Using Formula Bar.
a. Select the cell of which contents needs to be changed.
b. Click the formula area of formula bar.
c. Place your cursor according to modification and use backspace/delete key to remove the undesired contents and insert new data by simply entering it.

2. Using F2 key.
a. Select the cell of which contents needs to be changed.
b. Press F2 key.
c. Place your cursor according to modification and use backspace/delete key to remove the undesired contents and insert new data by simply entering it.

3. Using Double Click.
a. Double click on the cell of which contents needs to be changed.
b. Place your cursor according to modification and use backspace/delete key to remove the undesired contents and insert new data by simply entering it.

4. Replace the cell contents.
a. Select the cell of which contents needs to be replaced.
b. Start typing the new data. (Remember, its replacement not modification, so old data will be replaced with new content, you've just typed.)