cells

The Paste Special command can also be used to link an Excel worksheet. In contract to embedding, linking sets up a link between the worksheet cells in the document and the original Excel worksheet source. The MS Word document holds an image of the ... Excel worksheet and a shortcut to it but not an actual copy of the worksheet. Because of the link, any changes in the original are automatically reflected in the MS Word document. The advantage to linking the worksheet is that if the source worksheet in Excel changes, the values are automatically updated in the Word document. If you make a change in ... (view more)

You don't have to have two separate pages, one from MS Word and one from Excel, to display text and numbers in your document. This is because Word and Excel are built to work together, so that you can seamlessly bring your data from Excel into Word. ... Using Excel to generate your numeric data opens the door to more sophisticated calculations and numeric formatting. You can use all the features of Excel for making calculations, rather than being limited to the few formulas available on Word's Table | Formula command. Copying between Excel and Word uses the same techniques you know already: Open ... (view more)

Suppose your Excel worksheet has a long list of numbers to add. You can sum them instantly using Excel's AutoSum feature. Don't count on your fingers or pull out a calculator; Excel can calculate more quickly and accurately. Even more importantly, ... whenever a number changes, Excel instantly recalculates and displays the corrected sum. You can use either of these two methods to total the numbers using Excel: Click the cell below the list to make it the active cell. Click the AutoSum button. Excel surrounds the cells it thinks you want to total with a moving border. Press Enter or click the ... (view more)