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

Chapter 12. Working with Lists > Entering and Editing Data

Entering and Editing Data

Cells in a list are the same as other worksheet cells. You can use normal editing techniques to enter, delete, and modify list cell contents. In addition, you may find the following editing information useful.

To edit list data

To add new data to a list, you can use either of the following techniques:

  • Type data into each cell as you would in any worksheet. Press or to move to the next or previous cell. When you complete a row, a new row appears at the bottom of the list.

  • Choose Data > Form, or click the List icon on the List toolbar and choose Form (Figure 12.7). Use the Form dialog box to enter new records (Figure 12.8).

    Figure 12.7. Choose Form from the List pop-up menu on the List toolbar.


    Figure 12.8. You can optionally use a form to enter new records, edit existing records, or delete records.


To delete a selected record (list row), you can do either of the following:

  • Choose Edit > Delete Row, or click the List icon in the List toolbar and choose List > Delete > Row.

  • To clear the contents of the row without deleting it, choose Edit > Clear > Contents, or click the List icon and choose List > Clear Contents.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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