Objective 5. Copy Excel Data into a Word Document

Activity 1.5. Copying Excel Data to a Word Document

You can also use copy and paste with Excel to get information to use in other Office applications. You can select only the cells that contain the information you want to use.


On the taskbar, click the button to return to your Excel document, Meeting_Data_Firstname_Lastname.


Click and drag, starting in cell A1 and ending with cell D6. On the Standard toolbar, click Copy, and then on the taskbar, click the button to return to your Word document.


Find the paragraph after the Salary by Category table. After the paragraph, in the first blank line, click to position the insertion point. Press to create a new blank line for the data you will add.


On the Standard toolbar, click Paste. The information from the cells in Excel is added to the Word document as a table.

Tables in Word are easy to format and work with in your document. You can use Excel for performing any calculations and then copy your results to paste as table content into your Word document.

Compare your screen with Figure 1.5.

Figure 1.5.


Save your file. The Word document is now complete. Close the files for your Word document and your Access database. Leave the Excel file open to use in the next activity.

[Page 1352]

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