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

exportingimporting word

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

Exporting/Importing from Word

ResolvedVersion 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:

Auto-insert the current time

In Microsoft Excel, to enter the current time into a cell, hold CTRL+SHIFT and press SEMICOLON.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.