Microsoft Office Tutorials and References
In Depth Information
Importing and Exporting Your Excel Content
5. Click OK to remove all duplicates from the
6. View the results, displayed in a prompt
indicating how many duplicates were removed
and how many unique vales remain.
If you select only one or more (but not
all) of the columns in a series of multiple
contiguous columns for duplicate removal
(in Step 1), a prompt will appear
indicating that because the content in adjacent
columns’ cells was not selected, no
removals will occur unless you intervene.
You can choose to expand the selection
to include all the adjacent content, or you
can click the Remove Duplicates button
to continue the process as described in
the previous steps.
One of the great things about Microsoft
Office—and there are many—is that it’s really
easy to share content between applications in
the suite. It’s also easy to take content from
another non-Office application and bring it into
an Office document, workbook, presentation, or
database. Sharing in the other direction—from
Office to a non-Office application—is usually
pretty simple, too, thanks to the support Office
provides for saving and exporting your Office
creations (or portions thereof) in a variety of ways.
Using Word, PowerPoint,
and Excel Together
To create consistency across your Office-created
files, you’ll probably need to bring content from
a document or presentation into your Excel
workbooks at some point. From graphics in a
PowerPoint presentation to tables and text from
a Word document, there’s plenty of content that
can easily become part of an Excel workbook,
helping you to create a cohesive set of reports.
You may also want to share Excel content with
Word documents and PowerPoint presentations;
the sharing can go both ways, quite easily.