Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Embedding Excel worksheet objects directly into Word seems like a killer feature to me, but it would only be useful for publication if I could choose the "printable area" of the spreadsheet that gets fitted to the frame in Word. For the life of me I cannot figure out how to do this. Word only likes to show the first handful of cells in the top left corner. Resizing the frame just resizes these cells. Can this be done?

share|improve this question
add comment

1 Answer

What version of Office are you using? How are you pasting these in?

In Office 2003, I can copy an area on a worksheet in Excel and, in Word, select Edit > Paste Special > Paste: > Microsoft Office Excel Worksheet Object.

In this way, I have no limits on the number of cells that appear.

I know definitively that this was a limitation in Office XP, where only a certain number of columns could be displayed.

share|improve this answer
1  
+1You also have the choice to paste the area as a link and the content will update. –  datatoo May 26 '11 at 17:45
    
This is Word 2011 for Mac. I already knew I could embed a separate spreadsheet into a Word document (and even make a updatable link as datatoo said). What I wanted to do was make the spreadsheet only accessible from that document (and not from the filesystem). This can be done from Word now, but I haven't found a way to control the area displayed. Word only gives me the choice of showing an icon, or showing an unchangeable region of the spreadsheet. Paste special doesn't apply because Word 2011 automatically inserts the visible region. –  wdkrnls Jul 14 '11 at 20:04
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.