Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import / export data | New Users to Excel | |||
Import & Export | Excel Discussion (Misc queries) | |||
Import/Export | Excel Discussion (Misc queries) | |||
data import and export in to access | Excel Discussion (Misc queries) | |||
Automate Import/Export | Excel Discussion (Misc queries) |