A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Inserting a portion of an Excel Worksheet into Word



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2004, 01:50 PM
Adam
external usenet poster
 
Posts: n/a
Default 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  
Old May 28th, 2004, 02:35 PM
Jon Weaver
external usenet poster
 
Posts: n/a
Default 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  
Old May 28th, 2004, 03:24 PM
external usenet poster
 
Posts: n/a
Default 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  
Old May 28th, 2004, 05:51 PM
Jon Weaver
external usenet poster
 
Posts: n/a
Default 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  
Old May 29th, 2004, 12:16 AM
macropod
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.