Microsoft Office Tutorials and References
In Depth Information
To move a table to a new location in the same worksheet, move the mouse pointer to any of its borders. When
the mouse pointer turns into a cross with four arrows, click and drag the table to its new location.
To move a table to a different worksheet (in the same workbook or in a different workbook), do the following:
1. Select any cell in the table and press Ctrl+A twice to select the entire table.
2. Press Ctrl+X to cut the selected cells.
3. Activate the new worksheet and select the upper-left cell for the table.
4. Press Ctrl+V to paste the table.
Removing duplicate rows from a table
If data in a table was compiled from multiple sources, the table may contain duplicate items. Most of the time,
you want to eliminate the duplicates. In the past, removing duplicate data was essentially a manual task, but it's
very easy if the data is in a table.
Start by selecting any cell in your table and then choose Table Tools ⇒ Design ⇒ Tools ⇒ Remove Duplicates. Ex-
cel responds with a dialog box like the one 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 duplicate search. Most of the time,
you'll want to select all the columns, which is the default. Click OK, and Excel weeds out the duplicate rows
and displays a message that tells you how many duplicates it removed.
Unfortunately, Excel does not provide a way for you to review the duplicate records before deleting them. You
can, however, use Undo (or press Ctrl+Z) if the result isn't what you expect.
If you want to remove duplicates from a list that's not a table, choose Data ⇒ Data
Tools ⇒ Remove Duplicates.
Using a Data form
Excel can display a dialog box to help you work with a list 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 list 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 on the Ribbon. To use the Data form, you must add it
to your Quick Access toolbar:
1. Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar from the menu that appears.
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.