Microsoft Office Tutorials and References
In Depth Information
COPY A WORD TABLE
into Excel
If you create a table or other collection of data
structured as rows and columns in Microsoft Word,
you can import that information into Excel and take
advantage of Excel’s many features. Creating a table
in Word is often satisfactory; however, sometimes
you start creating a table in Word that becomes long
and elaborate. At that point, maintaining the
information in Excel may make more sense than
maintaining it in Word.
In Excel, you can perform calculations on the data,
use functions, and apply filters, all of which would be
time consuming, if not impossible, in Word. When
you copy a table from Word and paste it into an
Excel worksheet, you may lose some formatting, and
some of the data may transfer as text instead of
as numbers. You can correct these problems. For
information on converting text to numbers, see Task
#26. For information on formatting, see Task #s 68,
69, and 70. After you import the table into Excel, you
can proceed to add data to the list by using a form,
as explained in Task #36.
2
3
1
In Word, select the table you
want to copy.
2
Click the Home tab.
3
Click the Copy button.
Word copies the table to the
Windows Clipboard.
1
5
6
4
In Excel, click a cell, making sure
there are enough cells below and
to the right to accommodate the
Word table.
5
Click the Home tab.
4
6
Click Paste.
200
Search JabSto ::




Custom Search