Editing the Data

Sometimes you need to go back into a worksheet and make changes to your data. You can correct the data quickly and easily, either by replacing the contents of an entire cell or by editing the existing content.

Replace the Data

  1. Click in the cell, or use the arrow keys to select the cell whose data you want to replace.

  2. Type the new data, and press Enter.

    Replace the Data

Edit the Existing Data

  1. Double-click the cell to activate it for editing, or select the cell and press F2.

  2. Click or use the arrow keys to move the insertion point to where you want to do your editing.

  3. Use the Backspace or the Delete key to remove the data you don’t want, and type the new information. Press Enter when you’ve finished.

    Edit the Existing Data

Tip

Tip

To select an adjacent cell and set the direction in which the selection moves when you press Enter, choose Excel Options from the Office menu, and, in the Advanced category, select the After Pressing Enter, Move Selection check box. Then, in the Direction list box, select the direction in which you want the selection to move.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset