Page 522 - Excel 2013 All-in-One For Dummies

504 Excel 2013 Data Sharing Basics
If you don’t want gridlines to appear in the worksheet data that you copy to a Word document (as shown in Figure 4-5), be sure to remove their display in Excel before you do the copying. To remove gridlines from a worksheet, you just deselect the Gridlines check box in the Show/Hide group of the View tab on the Ribbon (or press Alt+WVG).
Editing embedded stuff
The great thing about embedding Excel stuff (as opposed to linking, which I get to in a later section) is that you can edit the data right from within Word. Figure 4-6 shows the table after I centered it with the Center button on Word’s Formatting toolbar. Notice what happens when I double-click the embedded table (or click the table once and then choose Worksheet Object➪Edit from the table’s shortcut menu): A frame with columns and rows, scroll bars, and the Cookie Sales sheet tab miraculously appears at the bottom of the table. Notice, too, that the tabs on the Word Ribbon have changed to ones on the Excel Ribbon. (It’s like being at home when you’re still on the road.) At this point, you can edit any of the table’s contents by using the Excel commands that you already know.
Figure 4-6:
Editing the embedded worksheet sales data in the Word memo.