O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

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

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required