• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Editing Data

Double-click the cell you want to edit. The insertion point appears to the left of the data in the current cell (the entry also appears in the Formula bar).

Press the left and/or right arrow keys to move the insertion point where you want to make the change.

Type your changes (using the Backspace key if necessary).

Press the Enter key to accept your changes (the cell below becomes the active cell).

INTRODUCTION

Being able to make changes to the values in your worksheet is what makes Excel such a valuable analysis tool. You can change any of your entries and see how that affects the formulas in your worksheet. To put the active cell in Edit mode, press F2 on the keyboard or click the mouse pointer on the data line of the Edit bar. You can then continue typing at the end of the current data, use the Backspace key to delete some data, use the left and right arrow keys to move through the data, or use the Home and End keys to move quickly to the beginning or the end of the data. Press Enter when you have finished editing the data.


TIP

Pressing the Enter key

You can't press an arrow key to confirm the entry and move to another cell. You must press Enter.


Click in the next cell you want to edit and press the F2 key. The insertion point appears to the right of the data in the current cell (the entry also appears in the Formula bar).

Type your edits.

Click the green checkmark Enter button to accept the changes.

The changes are accepted and the edited cell remains the active cell.

TIP

Selecting characters

You can drag the mouse pointer across characters to select them. Press the Delete key to delete the selected characters.


TIP

Copying and moving

In addition to editing data, you might find it useful to copy and move data to a different location. See the tasks “Cutting, Copying, and Pasting Data” and “Moving Data” later in this part for more information on copying and moving data.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint