3
0
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?
1+1You also have the choice to paste the area as a link and the content will update. – datatoo – 2011-05-26T17:45:31.680
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 – 2011-07-14T20:04:25.713