Microsoft® Office Excel 2003 Inside Out

Using Excel's Form Command to Work with Lists

You can add new information to a list by moving to the first blank row below the list and typing, but you might find it easier to choose Data, Form. The Form command generates a dialog box that can help you—or someone else who uses the list you design—add data to and otherwise manipulate your list. Figure 28-12 shows this data-entry form in the context of the staff list shown in Figure 28-1.

Figure 28-12. The Form command generates a no-frills dialog box for manipulating information in a list.

At the top of the form, Excel displays the name of the worksheet (not the workbook) that contains the list on ...