Microsoft Office Tutorials and References
In Depth Information
Chapter 23: Data Forms and Features Eliminated in Excel 2007 and 2010
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.
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
Figure 23.2 displays the menu.
Using the form you can do one or more of the following:
Add a record:
n Click New.
n Type the information for the new record.
n When you
nish, press Enter to add the record.
Change a record:
Find the record you want to change.
To move through records, use the scroll bar arrows in the dialog box. To
move through 10 records at a time, click the scroll bar between the arrows.
To move to the next record in the range or list, click Find Next.
To move to the previous record in the range or list, click Find Prev.
Search a record using conditions:
n Click Criteria, and then enter the criteria into the form.
nd records that match the criteria, click Find Next or Find Prev.