Microsoft Office Tutorials and References
In Depth Information
Converting a Table to a Range
Then click the Remove Duplicates
button in the Tools button group,
which will bring up the dialog shown
in Figure 7–35.
Figure 7–35. The Remove Duplicates dialog box
You can probably figure out what to
do next—just click OK. Because our
table contains two people with the
same last name but different first
names, we leave both columns
checked, which means that Excel
will search the data only for records
in which both fields are identical.
When you click OK, you’ll see the
message shown in Figure 7–36.
Figure 7–36. Yeah, “1 duplicate values” needs a
grammar check . . . but it worked!
Click OK and you’ll be left with three records, as one of the two John
Walshes has been deleted.
Converting a Table to a Range
If you want convert a table back to the standard database with which you started, click
Convert to Range in the Tools button group on the Table Tools tab. You’ll be prompted to
convert the table back to a “normal” range (as Excel puts it)—just click OK. Remember,
after all, that a database is also just a range, too.
NOTE: When you convert a table back to a range, any table formatting you may have applied,
such as banded rows and/or columns, will remain.
And given the advantages of turning a range into a table, why would you want to return
it back to standard range status? That’s a good and subtle question, and while you’re
not likely to convert it back to a normal range, there are some potential reasons why you
might. For one, if you delete a record in a table—even the last record—the records on
either side of the deleted row still remain in the table, and that means the blank rows will
appear in pivot table reports.
Search JabSto ::

Custom Search