Excel 2000 in a Nutshell

Name

Data → Form

Synopsis

Provides an easier method for entering data into a list. When you select this option a dialog displays, as shown in Figure 9-8, where you can add new data for your list, remove data from the list and locate a specific data record.

Figure 9-8. Dialog that displays when selecting Data → Form

Before selecting Data → Form, make sure you have at least one of the cells in the range selected. You will be able to add new data to your list as long as there are empty rows available between the list and other data on your worksheet. For example, if you only have one blank row between the end of your list and a row of column totals for the list, the dialog will only allow you to add one new data row.

You can scroll through the data in the list either by using the vertical scroll bar or by selecting the Find Prev and Find Next buttons. If you want to look at the records that meet a certain criteria, such as sales amounts over $30,000, you can select the Criteria button and then type the search criterion in the appropriate fields, >$30,000 in the Amount field for this example. Then select the Find Prev and Find Next buttons to scroll through the list of records that meet the specified criteria. Once you specify the search criterion, Excel continues to use that criterion to scroll through data records. To remove the search criterion and view all data, select the Criteria ...