Number of rows/columns displayed in Excel object in Word

[Carpetman]

How do I tell Word2004 for Mac how many rows/columns to display in an
embedded Excel worksheet?

When I edit the worksheet in Word2003 for PC, it opens a ’window’
within word so that I can drag the edges to display the number of
rows/columns that I want. It does not do this in Word2004 for Mac, but
opens the spreadsheet in Excel.

Are there any codes within word that say ’display cells a1 to z54’, or
whatever word does when it decides what cells it shoud display?

All the help files I’ve searched on ’size of object’ refer to scaling
the object. A 35 minute telephone call to Microsoft’s help line did
not get me any further towards a solution.

 

[Daiya Mitchell]

Haven't a clue, but also don't understand...

Is your problem that the embedded object does not display as you wish--or
that when you click to edit it, it shows too many cells in the editing
process?

 

[Carpetman]

Haven't a clue, but also don't understand...

Is your problem that the embedded object does not display as
you wish--or
that when you click to edit it, it shows too many cells in the
editing
process?




--
Daiya Mitchell, MVP Mac/Word
Word FAQ: http://www.word.mvps.org/
MacWord Tips: <http://www.word.mvps.org/MacWordNew/>
What's an MVP? A volunteer! Read the FAQ:

OK, say I want to create a table that has 11 columns and 40 rows. I do
it in Excel because I can set up the maths and its easier (and more
reliable) to revise the data. The Excel spreadsheet exists as an
embedded object in Word because it sits in the flow of the text and it
all gets saved in one document (easier to copy and revise for the next
project).

When I insert an Excel Spreadsheet object in Word2004 for Mac it
defaults to displaying 10 columns and 5 rows, regardless of how many
cells are occupied in the spreadsheet. The other cells remain ’hidden’
when I view the spreadsheet as it is displayed in Word.

How do I tell Word to display the cells I want it to display?

My only work-around at present is to open the Word document in
Word2003 for PC, double click the object and drag the
"frame"/"window" to show the cells I want.

 

[Carpetman]

Oops...

I should have said Word2004 for Mac defaults to 5 columns and 10 rows.

 

[Stan Hadley]

I found that once you create the worksheet that you inserted (that is only
showing 10rowx5column) you double-click on it (to get into Excel), highlight
the area you want, copy (cmd-c), switch back to Word _without closing the
spreadsheet_, and pick Paste Special.../Unknown Object, then you will get
the cells you want showing in a second object. Then you can delete the
first, 10x5, one and you're set. The "Unknown Object" choice only shows up
if you have the Excel file still open.

Hope this helps,

Stan

 

[Carpetman]

I found that once you create the worksheet that you inserted
(that is only
showing 10rowx5column) you double-click on it (to get into
Excel), highlight
the area you want, copy (cmd-c), switch back to Word _without
closing the
spreadsheet_, and pick Paste Special.../Unknown Object, then
you will get
the cells you want showing in a second object. Then you can
delete the
first, 10x5, one and you're set. The "Unknown Object" choice
only shows up
if you have the Excel file still open.

Hope this helps,

Stan


On 3/29/05 6:02 PM, in article
(e-mail address removed),
"Carpetman"

and 10 rows.

Stan,

Thanks for the workaround. It works but it is incredibly clunky.

An alternative approach is to construct the tables in separate
spreadsheets in Excel, then to paste special > Excel Spreadsheet
Objects into Word. But what happens if I want to add in a column
later? I’ll have to copy the spreadsheet out of word into excel, add
the column, copy and paste special back into word and delete the
previous version.

As far as coding is concerned, would it not be more elegant to link
the ’window/viewport’ to cells A1 to Z24 (or whatever) on the
spreadsheet object? You could even make different ’viewports’ for the
same spreadsheet object, which would be nice because you would not
have to link your data amongst a thousand-and-one different objects.