Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition

Chapter 23

Data Forms and Features Eliminated in Excel 2007 and 2010

This chapter gives me an opportunity to explain how to add features that were eliminated in Excel 2007 and 2010. A few elements disappeared in this version. One of them is the Data Form.

A data form is a dialog box that gives you a convenient way to enter or display one complete row of information, or record, in a range or list. The Data Form feature was eliminated in Excel 2007. However, the Data Form and other features that were eliminated can still be activated through the Quick Access menu.

To get the Data Form menu or any other Excel commands that were not carried through in Excel 2007 and 2010:

1. Click on the Customize Quick Access toolbar.

2. Select More Commands.

3. Change the type of commands requested to Commands not in the Ribbon.

4. Select Forms and click on Add.

The Quick Access menu will now show the Forms icon. See Figure 23.1.

FIGURE 23.1 Adding Command Icons to the Quick Access Menu

To activate the Data Form, select any cell in the range/table and click on the Data Form icon in the Quick Access menu. If you are familiar with Excel 2003 shortcuts, you can use the keyboard shortcut ALT + D + O.

Figure 23.2 displays the menu.

FIGURE 23.2 The Database Form Menu

Using the form you can do one or ...