How to Select Excel Area to Show in Word Document?

[gbhawkins]

I have a word 2004 document and I chose insert, object, spreadsheet.
It opens a up a blank spreadsheet and I put in various rows and
columns of data. How do I select what rows and columns I want to show
in the word document so that when I go back into the document only
those items show? Also, if I change what I want to show how do I
change it. Note- I am not talking about inserting an external
spreadsheet.

 

[CyberTaz]

No, you're not talking about inserting an external spreadsheet... But,
unfortunately, you should be

Word's implementation of OLE on the Mac leaves a bit to be desired. In order
to display more than a 5 column by 10 row matrix - especially an area of
your own preference rather than A1:E10 you'll need to create the file as an
Excel workbook, copy the desired range then go to Word & use Edit> Paste
Special - MS Excel Worksheet Object.

To avoid having to recreate from scratch, double-click the Existing embedded
sheet, select & copy your content, delete the object, then Quit Excel.
Launch it directly & paste your content into a new blank workbook. Save the
file (at least for the time being), then re-copy it, go back to Word & Paste
Special as above.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[gbhawkins]

Thanks. I understand those limitations. My question is for those
smaller than those sizes- say I have an OLE (not cut and pasted) with
5 columns and three rows but I only want to show 2 columns and one
row- how do I fix it so only that portion shows? What if I decide to
later change it to 3 columns to show in the word document? I do not
want to get into cutting and pasting.

Also, do you know if the new Office 2008 fixes the size limitations?

 

[gbhawkins]

OK, Cybertax, I actually figured out how to do what I wanted without
cutting and pasting. Do you know if the Office 2008 version has the 5
column by 10 row limitation?

 

[CyberTaz]

Even if I knew I'd be bound by non-disclosure to not reveal anything about
the 2008 release. The only 'official' sources of reliable info are the
MS-Mac web sites and/or press releases - but I've seen no reference to OLE
in either of those sources... They normally tout new features & major
changes but don't go into blow-by-blow tweaks to each feature.

 

[gbhawkins]

Thanks much for your help.