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

Chapter 10. Analyzing Worksheet Data > Managing Records Using a Data Form

Managing Records Using a Data Form

You can use a Data Form to display, edit, or delete selected records in a list. To display only selected records in the Data Form, you can specify the search criteria—the information a record must contain—in the Data Form, and Excel uses that criteria to find and display matching records. Although the Data Form shows only the records that match your criteria, the other records still exist in the list. If more than one record matches your criteria, you can use the Data Form buttons to move through the records, editing or deleting them.

Display Selected Records

Click anywhere within the list range.

Click the Data menu, and then click Form.

Click Criteria.

Type the information you want matching records to contain.

Click Find Prev or Find Next to advance to a matching record.

Repeat step 5 until Excel beeps or all records have been viewed.

Click Close.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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