Objective 4. Create Excel Worksheet Data from a Word Table

Activity 2.5. Creating Excel Worksheet Data from a Word Table

You can select an entire table in different ways:

  • Click anywhere in the table. On the Table menu, point to Select, and then click Table.
  • Click and drag across the table to select all the table rows and columns.
  • In Print Layout view, move the mouse over the table, and then click the four-headed arrow at the upper left corner of the table.
  • Move the mouse pointer to the left of the table. The mouse pointer will point to the right. Click and drag down the left side of all rows of the table.


In your Word document, select the entire table that shows the data for the West Campus. On the Standard toolbar, click Copy.


On the taskbar, click the button to return to your Excel file. Click the sheet tab labeled West Campus.


Click in cell A1, the first cell in the first row. On the Standard toolbar, click Paste.

The information from the Word table is copied to the rows and columns in the Excel worksheet. Column sizes are not copied from Word into Excel. Compare your screen with Figure 2.6.

Figure 2.6.


Save and then Close your Excel file. Close the Word file.


This integration project is now complete.

[Page 1365]

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

Chapter One. Creating Documents with Microsoft Word 2003

Chapter Two. Formatting and Organizing Text

Chapter Three. Using Graphics and Tables

Chapter Four. Using Special Document Formats, Columns, and Mail Merge

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

Chapter One. Using Access Data with Other Office Applications

Chapter Two. Using Tables in Word and Excel

Chapter Three. Using Excel as a Data Source in a Mail Merge

Chapter Four. Linking Data in Office Documents

Chapter Five. Creating Presentation Content from Office Documents

Go! With Microsoft Office 2003 Brief
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net