Microsoft Office Tutorials and References
In Depth Information
Working with Tables
Using a Data form
Excel can display a dialog box to help you work with a worksheet database or table. This Data
form enables you to enter new data, delete rows, and search for rows that match certain criteria,
and it works with either a worksheet database or a range that has been designated as a table
(choosing the Insert➜Tables➜Table command).
Unfortunately, the command to access the Data form is not in the Ribbon. To use the Data form,
you must add it to your Quick Access toolbar:
1. Right-click the Quick Access toolbar and select Customize Quick Access Toolbar.
Excel displays the Quick Access Toolbar tab of the Excel Options dialog box.
2. From the Choose Commands From drop-down list, select Commands Not in the Ribbon.
3. In the list box on the left, select Form.
4. Click the Add button to add the selected command to your Quick Access toolbar.
5. Click OK to close the Excel Options dialog box.
After performing these steps, a new icon appears on your Quick Access toolbar.
Excel’s Data form is handy but is by no means ideal. If you like the idea of using a dialog box to
work with data in a table, check out my Enhanced Data Form add-in. It offers many advantages
over Excel’s Data form. Download a free copy from my Web site: www.spreadsheetpage.com .
Removing duplicate rows from a table
If you have a table that contains duplicate rows, you may want to eliminate the duplicates. In the
past, removing duplicate data was essentially a manual task, but it’s easy if your data is in a table.
Start by selecting any cell in your table. Then choose Table Tools
Duplicates. Excel responds with the dialog box shown in Figure 9-5. The dialog box lists all the
columns in your table. Place a check mark next to the columns that you want to include in the