Edit the Contents of a Spreadsheet Cell

You can edit the contents of a cell in several distinct ways. Use the method that is most convenient for you.

Steps

1. Double-click the cell you would like to edit. The cell is placed in edit mode and the cursor is placed where you double-clicked. - or -
2. Press the F2 key on the keyboard. The cursor is placed at the end of the text. - or -
3. Click anywhere in the formula bar. The formula bar changes to have an X and check mark.

Tips

• You can tell you are in edit mode in several ways but the easiest way to tell is because the X and the check mark on the formula bar are active.
• To get out of edit mode either click in another cell or press Enter key (for those people who have not edited the behavior of Enter).
• These first two methods work on Microsoft Excel, OpenOffice.org Calc, or Google Spreadsheets. The last method works in Excel and Calc but not Google spreadsheets.

Related Articles

• Make a Timesheet
• Edit Data in Microsoft Excel
• Make a Spreadsheet in Excel
• Use Google Spreadsheets
• Recover Data from the Hard Drive of a Dead Laptop

See also

• Use Google Spreadsheets
• Read and Interpret a Spread Sheet
• Create an XL Worksheet for Continued Fractions
• Create a Graph Using a Spreadsheet
• Add a Column in a Pivot Table
• Create a Spirallic Numbers Dataset
• Do Cost Volume Profit Analysis
• Bulldog Through an Intellectually Simple Problem
• Use the Newton Raphson Method of Quickly Finding Roots
• Add Two Cells Already Containing Sum of Other Formulas

Read more ...

What links here

• Copy Formulas in Excel
• Create a Form in a Spreadsheet
• Learn Spreadsheet Basics with OpenOffice.org Calc
• Select Alternate Rows on a Spreadsheet
• Prepare an Employee Datasheet with EsCalc