Objective 3. Create a Table in Word from Excel Data

Activity 2.4. Creating a Table in Word from Excel Data

You can copy and paste data from an Excel worksheet into Word. Word will create a table from the information. You can format this table as you would any other table you create in Word.


In the document, scroll down to see the heading East Campus. After the heading, on the first blank line, position the insertion point.

The information from the Excel worksheet will be pasted here.

[Page 1362]


Start Excel. From the folder that contains your project files, Open the file Campus_List.xls. Save the file as Campus_List_Firstname_Lastname

When you select data in the rows and columns in Excel, select only the cells, not the row numbers that display to the left of the rows or the column letters above the columns.


Select the cells in the Excel worksheet that show the lab locations and information for the East Campus. On the Standard toolbar, click Copy.

Excel displays a moving border around the selected cells to verify your copy selection.


On the taskbar, click the button to return to your Word document. The insertion point should be under the East Campus heading. On the Standard toolbar, click Paste.

This adds the selected data from the Excel worksheet to your Word document. It will be similar to the table structure you created in the previous activity. The column sizing and bold headings were formatted in Excel and are copied into Word. Compare your screen with Figure 2.5.

Figure 2.5.


Save your Word file, and leave it open for the next activity.

[Page 1363]

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