Inserting a portion of an Excel Worksheet into Word

[Adam]

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

 

[Jon Weaver]

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

 

[Guest]

Thanks Jon,

But this loses all the formulas; I need the formulas to
work also.

Adam

 

[Jon Weaver]

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

 

[macropod]

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