• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Editing Cell Data

The easiest way to change a cell's contents is to select the cell and then type over the current data. But if the cell contains a formula or a lengthy text string, it's often faster to edit the current contents rather than retype.

To edit a cell's contents

1.
Do one of the following:

  • Click the cell to select it. (Selecting a cell automatically selects its entire contents.) Type to replace/overwrite the contents.

  • Double-click the cell to set the insertion point in the cell's text (Figure 9.11).

    Figure 9.11. You can edit cell data directly in the cell...


  • Click the cell to select it. Set the insertion point in the text displayed in the Formula Bar (Figure 9.12).

    Figure 9.12. ...or in the text box on the Formula Bar.


2.
Edit the contents in the cell or in the Formula Bar using the same techniques as you would if editing text in Word.

For example, you can delete the previous character or a selection by pressing , insert additional characters, or move left or right within the contents by pressing the left- or right-arrow key.

3.
To complete the edit, move to another cell; click the Enter icon on the Formula Bar; or press , , , or another navigation key.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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