MS-Excel / General Formatting

Editing Worksheet Data

Not everyone enters data correctly the first time. To edit data you entered in a cell, do one of the following:

  • Double-click the cell. Doing so places the cursor squarely in the cell, where you can start deleting or entering numbers and text.
  • Click the cell and press F2. This technique also lands the cursor in the cell.
  • Click the cell you want to edit. With this technique, you edit the data on the Formula bar.

If nothing happens when you double-click, or if pressing F2 lands the cursor in the Formula bar, not a cell, somebody has been fooling with the Options settings. Click the Office button, choose Excel Options, select the Advanced category in the Excel Options dialog box, and click the Allow Editing Directly in Cells check box.

[Contents] [Next]

In this tutorial:

  1. Refining Excel Worksheet
  2. Editing Worksheet Data
  3. Moving Around in a Worksheet
  4. Better Look at the Worksheet
  5. Freezing and splitting columns and rows
  6. Your own customized views
  7. Hiding columns and rows
  8. Comments for Documenting Your Worksheet
  9. Selecting Cells in a Worksheet
  10. Deleting, Copying, and Moving Data
  11. Handling the Worksheets in a Workbook
  12. Tampering with Worksheets
  13. Hiding a worksheet
  14. Protecting a worksheet