Page 521 - Excel 2013 All-in-One For Dummies
P. 521

Excel 2013 Data Sharing Basics 503
 As I passed over the border between the Excel and Word program windows, the mouse pointer changed shape to the international “oh-no-you-don’t” symbol. When I reached the safe havens of the Word document area, how- ever, the pointer changed again, this time to the shape of an arrowhead sticking up from a box with a plus sign. (How’s that for a description?) To indicate where in the Word document to embed the selected data, I simply positioned the arrowhead-sticking-up-from-a-box-with-a-plus-sign pointer at the place in the document where the Excel stuff is to appear. Then I released the mouse button. Figure 4-5 shows you the embedded worksheet table that appeared after I released the mouse button.
You can also use the cut-and-paste method to embed worksheet data into
a Word document. Simply select the cells in Excel and then copy them to the Clipboard by clicking the Copy button on the Home tab of the Ribbon (Ctrl+C). Then, open the Word document and position the cursor at the place where the spreadsheet table is to appear. Click the Paste Special option on the Paste button’s drop-down menu on the Home tab of Word’s Ribbon (or press Alt+HVS). Click Microsoft Excel Worksheet Object in Word’s Paste Special dialog box and then click OK. Word then embeds the data in the body of the Word document just as though you had Ctrl+dragged the data from the Excel window over to the Word window.
   Figure 4-5:
Word memo after copying the worksheet data.
 Book IV Chapter 4
 Sharing Workbooks and Worksheet Data



























































































   519   520   521   522   523