excell
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excell

Excell

resolvedResolved · Low Priority · Version 2003

replyReply Fri 6 Jun 2008, 16:35Delegate Robert said...

Robert has attended:
Excel Intermediate course

Excell

How do you insert an excel table in a word document

For upcoming training course dates see: Pricing & availability

replyReply Sun 8 Jun 2008, 23:47Trainer Katie said...

RE: Excel table in Word

Hi Robert,

Thank you for your question. In order to put an Excel table into a Word document, you can:

1) Copy the table in Excel and paste in Word. This way the data is not linked to the original Excel spreadsheet, the figures will not be updated.

or

2) In Word document, select Insert menu > Object, then select Create From File and Browse. Find your Excel file then press OK. This way the figures is linked to the Excel spreadsheet.

Hope this is useful.

Katie
Microsoft Certified Trainer

 

Please browse our web site to find out more about
excel training course and other Microsoft training courses.

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard