exportingimporting word

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Exporting/Importing from Word

Exporting/Importing from Word

resolvedResolved · Medium Priority · Version 2003

Jyoti has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

Exporting/Importing from Word

How can I import and export between excel and word?

RE: Exporting/Importing from Word

Jyoti,

To answer your question:

To import from Excel to Word:

1. In Word, display the Database toolbar. View - Toolbars - Database.

2. Click on the Insert Database button (hover your mouse pointer over the buttons to find it)

3. Click on Get Data.

4. Look for the Excel file that you wish to import, then select the worksheet that you wish to import.

5. Click on Insert Data

Word to Excel

Simply Copy from Word and Paste in Excel (or use Paste Special).

I hope this answers your question. If it doesn't please get back to me.

Thank you

Greg


 

Excel tip:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

View all Excel hints and tips


Server loaded in 0.08 secs.