Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 13th 09, 12:34 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 2
Default Export or Import into WORD

Is it possible to export or import a worksheet into WORD? I want to be able
to see all the columns and rows as they are seen in Excel.

  #2   Report Post  
Old May 13th 09, 01:10 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
Posts: 7
Default Export or Import into WORD

Copy the information you want from Excel. Switch to Word and Select Paste
Special, In the Paste Special window, select the Microsoft Office Excel
Worksheet Object and click OK. Then Double Click the object and you will see
all the row and column headings along with the sheet tabs.
--
Dave Herard
MOS Master Instructor
Microsoft Certified Trainer
www.clicknlearnct.com


"l_croft1" wrote:

Is it possible to export or import a worksheet into WORD? I want to be able
to see all the columns and rows as they are seen in Excel.

  #3   Report Post  
Old May 13th 09, 01:13 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default Export or Import into WORD

Sure, you can copy a block of cells and paste directly in a Word document.
This is the way to make a table in Word. You can copy from Excel as a
Picture and paste as a picture in Word. This gives you lots of flexibility
in re-shaping and moving.

Finally you can paste as an Excel Object
--
Gary''s Student - gsnu200852


"l_croft1" wrote:

Is it possible to export or import a worksheet into WORD? I want to be able
to see all the columns and rows as they are seen in Excel.

  #4   Report Post  
Old May 13th 09, 01:19 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 245
Default Export or Import into WORD

Does this help?

http://office.microsoft.com/en-au/wo...208101033.aspx

--
Steve

"l_croft1" wrote in message
...
Is it possible to export or import a worksheet into WORD? I want to be
able
to see all the columns and rows as they are seen in Excel.


  #5   Report Post  
Old May 13th 09, 03:58 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 293
Default Export or Import into WORD

Hi l_croft1,

Yes, via Copy (in Excel), then Edit|Paste Special (in Word).

Note: an Excel object cannot span more than one page in w Word document. If you need multiple pages, you'll need to copy & paste
each block from Excel separately. This can make the Word file very large. An alternative is to click on the 'link' option in the
Edit|Paste Special dialogue box. That keeps the Word file's size down and has the advantage that any changes to the Excel workbook
can update the Word document without the need to redo the copy/paste operation.

--
Cheers
macropod
[Microsoft MVP - Word]


"l_croft1" wrote in message ...
Is it possible to export or import a worksheet into WORD? I want to be able
to see all the columns and rows as they are seen in Excel.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import / export data Levi New Users to Excel 2 January 13th 09 06:14 AM
Import & Export lj Excel Discussion (Misc queries) 1 May 13th 08 02:07 AM
Import/Export ecruz04 Excel Discussion (Misc queries) 1 April 27th 07 08:17 AM
data import and export in to access nuti Excel Discussion (Misc queries) 10 January 5th 06 07:09 PM
Automate Import/Export Steve Excel Discussion (Misc queries) 0 October 14th 05 06:38 PM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017