If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Inserting a portion of an Excel Worksheet into Word
Is ther a way to insert a portion of an Excel Worksheet
into Word. I do not want an entire worksheet with scroll bars when I double click on Excel embedded object. Thanks Adam |
#2
|
|||
|
|||
Inserting a portion of an Excel Worksheet into Word
Adam,
Open the workbook in Excel and select the desired worksheet tab Select the range you want to copy to a Word document Click Copy on the Edit menu Open the document in Word you want to copy it to Move the insertion point to the place in the document you want to place the data from Word Click Paste Special on the Edit menu Make sure the Paste radio button is selected (*not* the Link radio button) Click Rich Text Format (RTF) Click OK The Excel data will be inserted within a table; the character formatting will be the same as that in Excel. You simply edit these characters in Word as you would characters (and paragraphs) in any Word table. Jon "Adam" wrote in message ... Is ther a way to insert a portion of an Excel Worksheet into Word. I do not want an entire worksheet with scroll bars when I double click on Excel embedded object. Thanks Adam |
#3
|
|||
|
|||
Inserting a portion of an Excel Worksheet into Word
Thanks Jon,
But this loses all the formulas; I need the formulas to work also. Adam -----Original Message----- Adam, Open the workbook in Excel and select the desired worksheet tab Select the range you want to copy to a Word document Click Copy on the Edit menu Open the document in Word you want to copy it to Move the insertion point to the place in the document you want to place the data from Word Click Paste Special on the Edit menu Make sure the Paste radio button is selected (*not* the Link radio button) Click Rich Text Format (RTF) Click OK The Excel data will be inserted within a table; the character formatting will be the same as that in Excel. You simply edit these characters in Word as you would characters (and paragraphs) in any Word table. Jon "Adam" wrote in message ... Is ther a way to insert a portion of an Excel Worksheet into Word. I do not want an entire worksheet with scroll bars when I double click on Excel embedded object. Thanks Adam . |
#4
|
|||
|
|||
Inserting a portion of an Excel Worksheet into Word
Adam,
Excel formulas don't work in Word; you can insert Word formulas if you wish (Formula on the Table menu). If you want to keep using Excel formulas, you're going to see the "worksheet with scroll bars" that you said don't want to see. To keep using Excel formulas, follow my previous instructions except that you should choose Microsoft Excel Worksheet Object instead of Formatted Text (RTF) -or- continue to choose Formatted Text (RTF) but select the Paste link radio button, which will maintain a link with the original Excel workbook. Jon ------------------ wrote in message ... Thanks Jon, But this loses all the formulas; I need the formulas to work also. Adam -----Original Message----- Adam, Open the workbook in Excel and select the desired worksheet tab Select the range you want to copy to a Word document Click Copy on the Edit menu Open the document in Word you want to copy it to Move the insertion point to the place in the document you want to place the data from Word Click Paste Special on the Edit menu Make sure the Paste radio button is selected (*not* the Link radio button) Click Rich Text Format (RTF) Click OK The Excel data will be inserted within a table; the character formatting will be the same as that in Excel. You simply edit these characters in Word as you would characters (and paragraphs) in any Word table. Jon "Adam" wrote in message ... Is ther a way to insert a portion of an Excel Worksheet into Word. I do not want an entire worksheet with scroll bars when I double click on Excel embedded object. Thanks Adam . |
#5
|
|||
|
|||
Inserting a portion of an Excel Worksheet into Word
Hi Adam,
You can't embed an Excel object that is editable without it also invoking Excel's scroll bars etc when you open it for editing. The nearest you could get to that is to construct a Word table that replicates your Excel file's layout. However, Word doesn't support the same range of formulae and worksheet management functions that you get in Excel. You could minimise the amount of the Excel workbook that is carried over into Word by creating an Excel object in Word and either: 1. copying & pasting into it the area you need from the Excel workbook; or 2. using Excel remote referencing formulae to point to the source data in the original workbook. There are benefits and drawbacks with either approach. The first option means the Excel object in the Word document can't be linked to the source file. Although the second option preserves the links, you have to open the embedded Excel object to update them. Cheers "Adam" wrote in message ... Is ther a way to insert a portion of an Excel Worksheet into Word. I do not want an entire worksheet with scroll bars when I double click on Excel embedded object. Thanks Adam --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004 |
Thread Tools | |
Display Modes | |
|
|