Microsoft Office Tutorials and References
In Depth Information
Importing and Exporting Your Excel Content
Arrow Shows Presence
of Word Table
The following examples, including instructions
for making them happen will give you a good
start on making all your Office files work
effectively together:
Word tables. These are perfect for use in
Excel, assuming they’re not populated
with long paragraphs of text, that is,
because they’re already in a grid. To bring
a Word table into your Excel worksheet,
simply select the table (click the
fourheaded arrow, as shown in Figure 14-30
or right-click the table and choose Select,
Table from the pop-up menu) and copy it
to the Clipboard by pressing Ctrl+C. Then
hop over to your Excel worksheet, click in
the cell where the pasted content should
begin (see Figure 14-31), and issue the
Paste command (Ctrl+V). Thanks to the
tabular structure, each cell in the Word
table becomes an Excel worksheet cell. To
go the other way, taking a block of cells
from an Excel worksheet and adding it to
a Word document as a table, simply select
the range of cells in Excel, copy them to
the Clipboard, and then go back to Word
and Paste. It’s really that simple!
Figure 14-30
Select your Word table and copy it—it’s ready to paste
into an Excel worksheet in a matter of seconds.
Figure 14-31
Paste that table, and you’ve got instant
worksheet content.
Tip
See that little Paste icon that appears (as shown in Figure 14-31) next to the pasted Word
table content? It allows you to choose your Paste Options. You can choose to include the Word
formatting that had been applied to the content while it was in the Word document (click the
icon on the left for this option), or to just paste the content itself (icon on the right), with no
formatting.
 
Search JabSto ::




Custom Search